Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Microsoft SQL Server › Backing Up and Restoring in Cluster Environments › Microsoft SQL Server 2000, 2005, 2008, 2012 and 2014 Cluster Environment › Select Server, Protocol, Security, and Backup Type

Select Server, Protocol, Security, and Backup Type

When performing backup jobs in a Microsoft Server cluster environment, you must first make server, protocol, security and backup type selections. Next, you must select a backup destination, set the backup schedule and submit the job.

To select a server, protocol, security, and backup type when backing up in a Microsoft SQL Virtual Server environment

1. Verify that Microsoft SQL virtual server is running in your Microsoft cluster environment.
2. Start Arcserve Backup and open the Backup Manager.
3. Click Options and then click the Agent Options tab to set Global Agent Options, if desired. For more information, see Backup Manager Agent Options.
4. On the Source tab, expand the Microsoft SQL Server virtual server name, not the physical nodes or the Windows virtual server. The Microsoft SQL Server virtual server instances are located under the Microsoft SQL Server virtual server object with which they are associated.

   Note: It is recommended that you browse the clustered Microsoft SQL Server instances through their associated Microsoft SQL Server virtual server names only. Browsing from any other entry point may cause backup failures if the Windows virtual server or the Microsoft SQL Server virtual server moves to a different node of the cluster. It is recommended that you do not browse through the MSCS computer name for clustered Microsoft SQL Server 2005, 2008, 2012 and 2014 instances.

   An instance of Microsoft SQL Server 2014 Express Edition that is used as the Arcserve Database of a clustered Arcserve Backup installation should be browsed through the virtual server name associated with the clustered Arcserve Backup primary server.

5. Right-click the Microsoft SQL Server instance and select Transfer Mechanism from the pop-up window.

   The Transfer Mechanism dialog opens.

6. Select Virtual Devices and click OK.
7. Right-click the Microsoft SQL Server instance and select Security.

   The Security dialog opens.

8. Verify the security information in the Security dialog and click OK.
9. Expand the Microsoft SQL Server instance to display a list of databases, and select a database.
10. Right-click the database and select Agent Options from the pop-up window.

    The Agent Backup Options dialog opens.

11. Select the type of backup you want to perform, and any subset options you wish to use. For more information about backup types, see Backup Methods.
12. If you chose the Files-and-FileGroups subset, click the Browse Files/FileGroups button.

    The Specify FileGroups and Files dialog opens.

13. Select the files or FileGroups you want to back up and click OK.
14. (Optional) In the Agent Backup Options dialog, enable a Database Consistency Check, select Database Consistency Check options, and click OK.

    Note: For more information about Database Consistency Checks, see Backing Up Microsoft SQL Server Databases and the Microsoft SQL Server documentation.

15. Repeat these steps for each database or database object you are backing up in this job.