Backing up transaction logs

This procedure describes how to perform a transaction log backup.

To back up a transaction log

  1. Set the Recovery Model setting to either Full or Bulk-logged.

    Caution:

    You must ensure that the entire sequence of transaction logs generated following any database backup are maintained on the same NetBackup server. All transaction logs same facility and that none should be allowed to expire before the others. NetBackup for SQL Server requires that you follow these guidelines when you plan your backup strategy. Then you have maximum assistance when you restore your databases.

  2. Change the host and instance you want to access.

  3. Select File > Backup SQL Server objects.

  4. In the Backup Microsoft SQL Server Objects dialog box, in the left pane, select the database instance.

  5. In the right pane, select one or more databases whose transaction logs you want to back up.

  6. In the Type of Backup list, select transaction log.

  7. From the drop-down list, select the transaction log option. For more information, see the following table.

    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 don't truncate it

    (SQL Server 2000) Backup a transaction log without truncating it.

    Truncate transaction log, but don't back it up

    (SQL Server 2005 or later) Truncate the log without performing a backup.

    Backup and restore tail log

    Back up and recover the tail log from disk.

  8. Select the backup options.

  9. Click Backup.

    To view the progress of the backup, select File > View status.

More Information

Selecting the SQL host and instance

Backup Microsoft SQL Server Objects field descriptions