Microsoft SQL Server 2000, 2005, or 2008 Cluster Environment Backups
76 Agent for Microsoft SQL Server Guide
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
(see page 29) and the Microsoft
SQL Server documentation.
15.
Repeat these steps for each database or database object you are backing up
in this 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.
