X hits on this document

435 views

0 shares

0 downloads

0 comments

68 / 200

68

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

Backing up transaction logs

To back up a transaction log

Before starting a transaction log backup, the database administrator should perform the following actions on the SQL Server.

If SQL Server 2000 or later is installed set the Recovery Model setting to either Full or Bulk-logged.

If SQL Server 7.0 is installed, set the Truncate Log on Checkpoint database option to Off. This is an option on the SQL Server interface that applies to the database.

1

Caution: You are responsible for ensuring that the entire sequence of transaction logs generated following any database backup are maintained on the same NetBackup server. This means that they should all be backed up to the same facility and that none should be allowed to expire before the others. NetBackup for SQL Server requires that you follow these guidelines in devising your backup strategy in order to provide maximum assistance in restoring your databases.

2

To change the host and instance you wish to access, refer to “Selecting the SQL host and instance” on page 63.

3 4

Choose File > Backup SQL Server objects.

In the Backup Microsoft SQL Server Objects dialog box, in the right pane, select one or more databases whose transaction logs you want to back up.

5

In the Type of Backup list, choose transaction log.

Document info
Document views435
Page views435
Page last viewedSun Dec 04 21:45:12 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments