To perform a partial backup

1. Change the host and instance you want to access.

2. Select File > Backup SQL Server objects.

3. In the Backup Microsoft SQL Server Objects dialog box, in the left pane, select the database instance.

4. In the right pane, select a database that you want to back up.

5. Select the Type of Backup.

   Select one of the following:

   • To perform a full backup, select Create a template for partial backup.

   • To perform a differential backup of the read-write filegroups, select Create a template for partial differential backup.

6. Select the backup options.

7. Click Backup.

8. In the Save Script As dialog box, specify a file name and click OK.

9. When you are prompted to open the template, click Yes.

10. 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
    

11. When you are finished modifying the template, save it.

12. To run the backup, select File > Manage script files, select the script you created, and click Start.