Configuring a policy for Instant Recovery backups of SQL Server
Note:
NetBackup does not support Instant Recovery backups of availability databases.
These instructions describe how to configure a policy for Instant Recovery. Optionally you can choose to back up to disk only. This topic only covers what is necessary to configure Instant Recovery backups for a MS-SQL-Server policy.
See About SQL Server Intelligent Policies.
See Adding a new SQL Server legacy policy.
See the NetBackup Snapshot Client Administrator's Guide for details on how to select the snapshot method and automatic snapshot selection.
To configure a policy for Instant Recovery
- For SQL Server legacy policies, create a backup script using the NetBackup MS SQL Client interface.
- Open the NetBackup web UI.
- Create a policy.
- Click the Attributes tab.
- From the Policy type list, select MS-SQL-Server.
- Select the Policy storage.
If you select an Instant Recovery option on the Schedules tab (see step 11), the storage unit is not used. NetBackup creates only a disk snapshot.
If database differentials, filegroup differentials, or transaction logs are included in the policy, then NetBackup performs a stream-based backup. This backup uses the selected storage unit. If a storage unit is not provided, then NetBackup uses the default storage unit for the server.
- Click Perform snapshot backups.
- Choose to have NetBackup select the snapshot method or select the snapshot method manually.
Perform one of the following:
By default, NetBackup chooses a snapshot method for you.
To use a specific snapshot method, click Snapshot options and select it from the Snapshot method list.
- Select Retain snapshots for Instant Recovery.
NetBackup retains the snapshot on disk, so that Instant Recovery can be performed from the snapshot.
A normal backup to storage is also performed, if you do not choose to create a snapshot only (see step 11).
- On the Instances and databases tab, choose how you want to protect SQL Server:
(SQL Server Intelligent Policy) Choose Protect instances and databases or Protect instance groups.
(SQL Server legacy policies) Choose Clients for use with batch files.
- To configure schedules, click the Schedules tab.
(SQL Server Intelligent Policies) Configure a full backup schedule.
(Legacy policies) Follow the instructions to configure an Application and a full backup schedule.
For snapshot backup policies, a full backup schedule must exist for NetBackup to successfully convert differential backups to full backups.
- (Optional) To create a disk image only, open the Full backup schedule (Intelligent Policies) or the Application schedule (legacy policies) and select an Instant Recovery option.
Select one of the following options:
If Snapshots and copy snapshots to a storage unit is selected, NetBackup creates a disk snapshot. NetBackup also backs up the client's data to the storage unit that is specified for the policy.
If Snapshots only is selected, the image is not backed up to tape or to other storage. NetBackup creates a disk snapshot only. Note that this disk snapshot is not considered a replacement for traditional backup.
(SQL Server Intelligent Policy) Add other policy information as follows:
(Optional) Select specific filegroups or files that you want to back up. By default, NetBackup backs up an entire database.
(Optional) Make changes to any tuning parameters.
(SQL Server legacy policies) Add other policy information as follows:
Add clients.
Add batch files to the backup selections list.
- Click Create to save the policy.