Performing partial database backups
This procedure describes how to create a script for to perform a partial database backup. This type of back is only available for SQL Server legacy backup policies.
To perform a partial database backup
- Open the NetBackup MS SQL Client interface.
- Select the host and instance you want to access.
- Select File > Backup SQL Server objects.
- In the Backup Microsoft SQL Server Objects dialog box, in the left pane, select the database instance.
- In the right pane, select a database that you want to back up.
- For the Type of Backup, select one of the following:
Create a template for partial backup.
Create a template for partial differential backup.
- Select the backup options.
- Click Backup.
- In the Save Script As dialog box, specify a file name and click OK.
- When you are prompted to open the template, click Yes.
- Edit the template by uncommenting the filegroups that you want to include in the backup. You must uncomment at least one filegroup.
For example, replace:
# # If you wish to include filegroup DBA_FG1 in the partial backup, # then remove the hash mark that precedes the following line. #FILEGROUP DBA_FG1
with:
# # If you wish to include filegroup DBA_FG1 in the partial backup, # then remove the hash mark that precedes the following line. FILEGROUP DBA_FG1
- When you are finished modifying the template, save it.
- To run the backup, select File > Manage script files, select the script you created, and click Start.