Result The backup operation is performed, and each item in the Backup Task List is checked off as the task is complete.
• You can toggle the Backup Status dialog box between two different views: Backup Task List view and Backup Report view.
• The Backup Report view displays detailed progress information as the backup progresses. You can also print this information by using the Print Report button.
• If the backup is successful, the Backup Task List view shows the check-off list with the tasks completed.
• If Notification is enabled, an email is sent and the event is posted to the Windows Application event log.
Full database backup using the Backup wizard
To start or schedule a full database backup using the Backup wizard, complete the following steps.
Note: For a list of information you need to provide as you complete these steps, see the section
"Information you need to specify for a full database backup" which appears earlier in this topic.
Step Action
1 In the SnapManager for SQL Server console root, click the SnapManager Backup wizard icon.
Result The SnapManager Backup wizard starts and displays the Welcome screen.
Welcome
2 Click Next.
Result The Databases to Backup or Verify screen appears. The Microsoft SQL Servers navigation tree in the left panel lists the SQL Server databases that are managed from the current SQL Server. Databases that reside on the same storage system and storage system volume are shown with disk icons of the same color.
Databases to Backup or Verify
Step Action
3 In the left panel, click to select the databases you want to backup.
You can back up all databases on an SQL server by selecting the server instead of selecting individual databases. When you select the server, even databases created after configuring the backup are backed up. If you have more than one SQL instance, you must repeat this process for each instance; however, instead of the selecting the server, you should select the instance.
When you select a database, SnapManager automatically selects all other databases that reside on the same storage system volume. For information about deselecting any automatically selected databases, see the bullet "Which databases you want to backup"
under "Job-specific parameters" in Managing transaction log backups using SnapManager on page 138.
When you select databases at the SQL Server instance level, SnapManager lists any offline databases as skipped in the backup report. For more information, see the section
"Information you need to specify for a full database backup" which appears earlier in this topic.
4 Click Next.
Result The Backup or Verify Databases and Transaction Logs screen appears.
Backup or Verify Databases and Transaction Logs
5 Select the Backup Databases and Transaction Logs option, and then click Next.
Result: The Select to Apply Backup Option window appears.
Note: If you do not select the Backup Databases and Transaction Logs option and select to schedule the transaction log backup yourself, ensure that the full backup and transaction log backup operations do not coincide.
Backup Option
6 If you want to... Then...
Add databases from remote servers or from different SQL instances
Select "Federated Backup Options." For more information, see Step 5 in "Full database backup using Backup and Verify" which appears earlier in this topic.
Take backups of single or multiple replicas of an Availability Group
Select "Availability Group Database Backup, and then select from Preferred Backup Replica Only, Primary, Secondary, All and optionally, Backup Priority.
Only back up databases from the selected server
Select "Continue with selected databases."
Select SQL Server backup Type
Protecting databases by backing up, replicating, and archiving | 135
Step Action
7 Select the Full Database Backup option, and then click Next.
Result The "Select backup management group for this backup" screen appears.
Select backup management group for this backup
8 Follow the instructions in the remainder of the Backup wizard screens.
The following screens enable you to specify the details of a full database backup:
• Backup Management Group
• Backup Transaction Log After Full Database Backup
• Delete the Oldest Full Backups
• Retain Up-to-the-Minute Restore Ability for Older Backups
Note: This screen appears only if you selected the Delete the Oldest Backups option in the previous screen.
• Verify the Databases in this Backup
• View or Change Verification Settings
Note: This screen appears only if you chose to automatically verify the databases when the backup is created.
• SnapMirror options and Backup archiving options (SnapVault)
Note: This screen appears only if any SQL Server databases or SnapInfo directories reside on a SnapMirror source volume.
• Advanced Backup Options
• Run a command or script with the current operation
For a list of information you need to provide, see the section "Information you need to specify for a full database backup" which appears earlier in this topic.
Backup Finish
9 The "Backup Finish" screen prompts you to choose whether you want the operation to be performed immediately or scheduled for a later time.
If you want to... Then...
Run the backup now Go to Step 10.
Schedule the backup for later Go to Step 12.
To run the backup now:
10 If you want to run the backup, Click Finish.
Result The Backup Status screen appears and displays the backup settings you have selected.
Step Action
11 In the Backup Status window, click Start Now.
Result The backup is performed and the backup set is written to the volume.
• The Backup Status dialog box appears and displays a Backup Task List that is used to show the progress of the backup operation after you start it.
• SnapManager Backup completes each task and checks it off on the list shown in the Backup Task List view.
• You can switch back and forth between the task check-off list and the progress report using the Switch buttons on either view.
• If the backup is successful, the Task window shows the check-off list with the tasks completed.
• If Notification is enabled, an email is sent and the event is posted to the Windows Application event log.
To schedule the backup for later:
12 If you want to schedule the backup for later, do the following: