Backing up SQL Server transaction logs
This procedure describes how to perform a transaction log backup.
Caution:
Ensure that the entire sequence of transaction logs generated following any database backup are maintained on the same NetBackup server. Back up all transaction logs to the same facility and do not allow any logs to expire before the others.
- In SQL Server, set the Recovery Model setting to either Full or Bulk-logged.
- Open the NetBackup MS SQL Client interface.
- Select the host and instance you want to access.
- Select File > Backup SQL Server Objects.
- In the Backup Microsoft SQL Server Objects dialog box, in the left pane, select the database instance.
- In the right pane, select one or more databases whose transaction logs you want to back up.
- In the Type of Backup list, select transaction log.
- 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.
Truncate transaction log, but don't back it up
Truncate the log without performing a backup.
Back up and restore tail log
Back up and recover the tail log from disk.
- Select the backup options.
- Click Backup.
To view the progress of the backup, select File > View status.