How to create a transaction log backup (Enterprise Manager)
To create a transaction log backup
- Expand a server group, and then expand a server.
- Expand Databases, right-click the database, point to All Tasks, and then click Backup Database.
- In the Name box, type the backup set name. Optionally, in Description, type a description of the backup set.
- Under Backup, click Transaction log.
Note If the Transaction Log option is unavailable, ensure that the recovery model is set to Full or Bulk-Logged. For more information, see Using Recovery Models.
- Under Destination, click Tape or Disk, and then specify a backup destination.
If no backup destinations appear, click Add to add an existing backup device or to create a new one.
- Under Overwrite, do one of the following:
- Click Append to media to append the backup to any existing backups on the backup device.
- Click Overwrite existing media to overwrite any existing backups on the backup device.
- Click Append to media to append the backup to any existing backups on the backup device.
- Optionally, select the Schedule check box to schedule the backup operation for later or periodic execution.
- Optionally, click the Options tab, and then do one of the following:
- Select the Verify backup upon completion check box to cause the backup to be verified when backed up.
- Select the Eject tape after backup check box to cause the tape to be ejected when the backup operation has completed. Available only with tape devices.
- Select the Remove inactive entries from transaction log check box to cause the inactive portion of the transaction log to be truncated, allowing Microsoft® SQL Server™
- to reuse this truncated, unused space.
- Select the Check media set name and backup set expiration check box to cause the backup media to be checked to prevent accidental overwrites. In the Media set name box, type the name of the media to be used for the backup operation. Leave blank when specifying only the backup set expiration.
- Select the Verify backup upon completion check box to cause the backup to be verified when backed up.
- If it is the first use of the backup media or you want to change an existing media label, under Media set labels, select the Initialize and label media check box and type the media set name and media set description. The media can only be initialized and labeled when it is being overwritten.