X hits on this document

412 views

0 shares

0 downloads

0 comments

66 / 200

66

Using NetBackup for SQL Server Using the NetBackup for MS SQL Client interface

Table 5-9

Options for backup operations

Option

Description

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.

Backup script

Launch Immediately

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.

Save

Generate a script that can be started at a later time.

Back up

Choose which objects to back up in the right-hand pane.

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.

Retry failed backups

Automatically retry unsuccessful backups.

NetBackup policy

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.

Page verification

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

Refer to “Configuring multi-stream operations” on page 38,

Backup

Start a database backup or generate a database backup script. This button is enabled only when you have selected an object to back up.

Document info
Document views412
Page views412
Page last viewedSat Dec 03 18:24:38 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments