Perform a user-directed backup of SQL Server transaction logs (NetBackup MS SQL Client)
This procedure describes how to perform a transaction log backup.
Caution:
Ensure that the entire sequence of transaction logs that are 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.
To back up a transaction log
- 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.
See Select the SQL Server host and instance (NetBackup MS SQL Client).
- 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 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 the disk.
- Select the backup options.
- Click Backup.
To view the progress of the backup, select File > View status.
More Information