Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide

To perform a partial database backup

1. Open the NetBackup MS SQL Client interface.
2. Select the host and instance you want to access.

3. Select File > Backup SQL Server objects.
4. In the Backup Microsoft SQL Server Objects dialog box, in the left pane, select the database instance.
5. In the right pane, select a database that you want to back up.
6. For the Type of Backup, select one of the following:

   • Create a template for partial backup.

   • Create a template for partial differential backup.

7. Select the backup options.
8. Click Backup.
9. In the Save Script As dialog box, specify a file name and click OK.
10. When you are prompted to open the template, click Yes.
11. 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

12. When you are finished modifying the template, save it.
13. To run the backup, select File > Manage script files, select the script you created, and click Start.