Backing Up the Current Transaction Log 

Use

If the disk on which the R/3 database resides has failed, it is important to immediately backup the current transaction log, otherwise the work carried out since the last log backup will be permanently lost.

Prerequisites

The current transaction log can only be dumped if:

Do not stop the SQL Server before backing up the current transaction log. If you stop the server or reboot the system, you will be unable to backup the log!

Procedure

  1. Insert a new tape into the tape device.
  2. In the Enterprise Manager, start the Query Analyzer. To do this, expand your server and choose Tools ® SQL Server Query Analyzer.

    3. The SQL Server Query Analyzer window opens.

  3. Enter the Transact SQL statement:

    4. BACKUP LOG <SAPSID> TO <backup device> WITH NO_TRUNCATE, FORMAT

    Where <SAPSID> is the name of your R/3 database and <backup device> the name of the device where you insert the backup tape, for example, R3DUMP0. Device names are case sensitive. For example, R3DUMP0 must be entered in uppercase.

    The format option of the backup log command erases all the existing data on the tape. You should therefore be absolutely certain that you have placed the right tape into the tape drive.

  4. Choose the execute icon to start the backup.