This procedure describes how to perform a partial backup. This type of backup can only be performed with SQL Server 2005 or later.
Note: |
Partial backups are not supported if you have SQL Express. SQL Server Express Edition has limited support for recovering from this backup type. |
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.
In the Save Script As dialog box, specify a file name and click OK.
Edit the template by uncommenting the filegroups that you want to include in the backup. You must uncomment at least one filegroup.
# # 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
# # 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
To run the backup, select File > Manage script files, select the script you created, and click Start.
More Information