Back Up a Database
Chapter 3: Backing Up Microsoft SQL Server Databases 43
9.
If you chose the Files-and-FileGroups subset, click the Browse button. The
Specify FileGroups and Files dialog opens.
Select the specific files and FileGroups you want to back up and click OK.
10.
(Optional) Enable a Database Consistency Check and select the Database
Consistency Check options. For more information about Database
Consistency Checks, see Database Consistency Checks and the Microsoft
SQL Server documentation.
11.
If you selected the Transaction Log backup type, or the Backup Transaction
Log After Database option, select a Transaction Log Truncation Option.
12.
Click OK.
13.
Repeat the preceding steps for each database you are backing up in this job.
14.
On the Destination tab in the Backup Manager, 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. For
information about scheduling backups, see the
Administration Guide
.
15.
Click Submit. The Security and Agent Information dialog opens.
Note:
In this dialog, the column and button labeled Agent refer to the Client
Agent for Windows, not the Agent for Microsoft SQL Server. You can edit
client agent information at this time. For more information about client
agents, see the
Administration Guide
.
Verify the user name and password for the target machine and for Microsoft
SQL Server. To change the security information for Microsoft SQL Server,
click Security and change the information in the dialog.
16.
After verifying or changing the security information, click OK. The Submit
Job dialog opens.
17.
(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.
18.
Click OK.
The job is submitted.
If you selected the Run Now option, the Job Status window opens. Use this
window to monitor the current status of your job. For more information
about the Job Status window, see the
Administration Guide
.
