Using NetBackup for SQL Server Using the NetBackup for MS SQL Client interface
Options for backup operations
Truncate transaction log, but don't back it up
(SQL Server 7 and SQL Server 2000) Transaction log is truncated, but is not backed up.
Back up and restore tail log
(SQL Server 2005) Back up and recover the tail log from disk.
Start the backup operation immediately.
Note: 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.
Generate a script that can be started at a later time.
Choose which objects to back up in the right-hand pane.
Back up only the objects selected.
All but selected
Back up all of the objects, except those selected.
Back up all of the objects.
Retry failed backups
Automatically retry unsuccessful backups.
If this host is the NetBackup master server, then this list includes all active policies of type MS-SQL-Server. You may select one of these policies, or type the name of a policy.
The default is <any>. If you choose the default, then NetBackup selects which MS-SQL-Server policy to use.
(SQL Server 2005 only) 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.
Note: There is a performance penalty when you use page verification.
Do not perform verification
Do not perform page verification before you run the backup.
Perform page verification when you run the backup and stop the backup if a verification error is encountered.
Set the number of backup stripes that you want SQL Server to create for your backup. Type a number from 1 to 32.
Refer to “Configuring multi-stream operations” on page 38,
Start a database backup or generate a database backup script. This button is enabled only when you have selected an object to back up.