Previous Topic: Select Server, Protocol, Security, and Backup TypeNext Topic: Restore by Tree in Microsoft SQL Server 2005, 2008, or 2012 Cluster Environments

Backing Up and Restoring in Cluster Environments › Microsoft SQL Server 2000, 2005, 2008, and 2012 Cluster Environment › Select Backup Destination, Schedule, and Submit the Job

Select Backup Destination, Schedule, and Submit the Job

After making server, protocol, security and backup type selections, you can select a backup destination, set the backup schedule and submit the job.

To select the backup destination, schedule, and to submit the job

  1. On the Backup Manager Destination tab, select a backup destination.

    Note: You can use the * symbol in the Group or Media fields to create partial wildcards when you select a backup destination. For example, if you have two sets of device groups, one with all members beginning GroupA and the other with all members beginning GroupB, you can select all the GroupA members by entering GroupA* in the Group field. For more information about selecting devices and media, see the Administration Guide.

    Click the Schedule tab and select the scheduling options for this backup job. For information about scheduling backups, see the Administration Guide.

  2. Click Submit.
  3. In the Security and Agent Information dialog, verify the user name and password for the Windows cluster where Microsoft SQL Server is running and for the Microsoft SQL Server instance. To enter or change security information for the computer or the Microsoft SQL Server instance, select the computer or the Microsoft SQL Server instance, click Security, enter the user name and password, and click OK.

    Note: We recommend that you use the user name and password of a domain administrator for machine authentication. Domain administrators are not dependent on the computer on which the Microsoft SQL Server instance is still running. Specify a domain user with the format DomainName\UserName.

  4. Click OK. The Submit Job dialog opens.
  5. (Optional) Use the Submit Job dialog to select the job execution time, submit the job on hold, add an optional job name for the backup job, or select source priority.
  6. Click OK to submit this job. If you selected Run Now, the Job Status window opens. Use this window to monitor your job. For more information about the Job Status window, see the Administration Guide.