Backup Microsoft SQL Server Objects field descriptions

Table: Options for 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.

Table: Options for 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. (Use Ctrl + click and Shift + click to select multiple objects.)

Type of Backup

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

The following backup types are only available for SQL Server 2005 or later:

  • Read/write filegroups

    Create a backup of read or write filegroups in a database.

  • Differential on read/write filegroups

    Create a differential backup of read or 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.

  • Truncate transaction log, but don't back it up

    (SQL Server 2000) Transaction log is truncated, but is not backed up.

  • Back up and restore tail log

    (SQL Server 2005 or later) Backup and recover the tail log from disk.

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.

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

(SQL Server 2005 or later) 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.

Stripes

Set the number of backup stripes that you want SQL Server to create for your backup. Type a number from 1 to 32.

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 multistream operations