Database Administration for Specific Platforms › SQL Server/Windows Routine Procedures › Backing Up Transaction Logs › Create a Log Backup to Disk or Tape

Create a Log Backup to Disk or Tape

These commands create a location to back up the transaction log information to disk. You can dump your logs to a tape by issuing a similar command.

1. Back up the Encyclopedia transaction log <DBCSE> using the transaction log dump device and the following Management Studio command:

   dump transaction DBCSE to DBCSE_LOG_DUMP
   

2. Back up the Coordination transaction log <DBDIR> using the transaction log dump device and the following Management Studio command:

   dump transaction DBDIR to DBDIR_LOG_DUMP