Options for SQL Server backup operations

Table: Options for SQL Server backup operations describes the options that are available when you perform backups. These options appear in the Backup Microsoft SQL Server Objects dialog box after you select File > Backup SQL Server objects.

Caution:

Do not enable multiplexing if the policy is also configured with multiple stripes. Restores fail when both multiplexing and multiple stripes are configured for a backup policy.

Table: Options for SQL Server backup operations

Option	Description
Expand database	This pane lets you traverse live databases. You can expand the SQL Server instance to view its databases. Expand each database to view its filegroups or expand a filegroup to view its files. You can select any object in this pane to view its constituent objects in the right-hand pane.
Select database(s) for backup from instance host\instance	Select the objects that you want to back up from this pane. This pane displays the list of constituent database objects of the selected host and instance in the left-hand pane. You can select one or more objects (databases) in this pane.
Type of Backup	The following backup types are available: Full Create a full database backup. Full differential Create a differential backup. transaction log Create a transaction log backup. This type of backup is only available for databases. When you select this type of backup, you then need to select a backup option from the Transaction log backup options list. Read/write filegroups Create a backup of read-write filegroups in a database. Differential on read/write filegroups Create a differential backup of read-write filegroups in a database. Create a template for partial backup Create a backup of only the selected filegroups in a database. Create a template for partial differential backup Create a differential backup of only the selected filegroups in a database.
Transaction log backup options	The following options are available when you have chosen a transaction log backup type: Back up and truncate transaction log Back up the transaction log and remove the inactive part of the transaction log. Back up transaction log, but do not truncate it Back up a transaction log without truncating it. Back up and restore tail log Back up and recover the tail log from disk.
Use SQL compression	Select this option if you want to use SQL Server to compress the backup image. If you enable SQL Server compression, do not enable NetBackup compression.
Backup script	Launch Immediately Start the backup operation immediately. Launch immediately is disabled if you are logged into a SQL Server instance that is not on the local host. If you generate a script for a non-local host, then it must be executed on that host. Save Generate a script that can be started at a later time.
Back up	In the right-hand pane, choose one of the following backup options: Selected Back up only the objects selected. All but selected Back up all of the objects, except those selected. All Back up all of the objects.
Stripes	Set the number of backup stripes that you want SQL Server to create for your backup. Type a number from 1 to 32. Caution: Do not enable multiplexing if the policy is also configured with multiple stripes. Restores fail when both multiplexing and multiple stripes are configured for a backup policy.
Resume options for this selection	Do not resume unsuccessful backups Retry from the beginning Restart failed backups after waiting 60 seconds. Save work and restart at point of failure Divide the backup into multiple streams and back up separately. Any streams that fail are restarted after 60 seconds. This option is available when the following conditions are met: Exactly one object has been selected, The object that is selected for backup is a database or filegroup and the backup type is full, The SQL Server object uses the "full" or "bulk-logged" recovery method.
NetBackup policy	If this host is the NetBackup master server, then this list includes all active policies of type MS-SQL-Server. You can select one of these policies or type the name of a policy. The default is <any>. If you select the default, then NetBackup selects which MS-SQL-Server policy to use.
Page verification	This option is enabled for objects have a page verification type that is either torn page detection or checksum. All of the objects in the right-hand pane must have the proper verification type. This indicates a performance penalty when you use page verification. Do not perform verification Do not perform page verification before you run the backup. Perform verification Perform page verification when you run the backup and stop the backup if a verification error is encountered.
Backup	Start a database backup or generate a database backup script. This option is enabled only when you select an object to back up.

More Information

Configuring multistriped backups of SQL Server

About legacy SQL Server policies

Options for SQL Server backup operations

Feedback

Feedback