Customizing a Backup Command

You can customize the backup command (the DUMP statement) that is built by SQL Enterprise Manager when you define a backup in the Database Backup/Restore window. To do this, you open the Schedule Backup dialog box.

    To customize the backup command
  1. Define the backup as described in Backing Up a Database or Transaction Log, earlier in this chapter.
  2. From the Database Backup/Restore window, choose the Schedule button.

    The Schedule Backup dialog box appears.

  3. As appropriate, change the text of the DUMP statement in the SQL Command box.

    For information about the syntax that can be used in the SQL Command box, see the discussion of the Dump Statement in the Microsoft SQL Server Transact-SQL Reference.

  4. Choose OK.

You modify the text in the SQL Command box by typing valid DUMP statement syntax. For example, if you are backing up the transaction log of the inventory database to the TAPE03 device, SQL Enterprise could have built this command for you:

DUMP TRANSACTION inventory TO tape03 WITH UNLOAD, NOINIT, SKIP

If you need to truncate the log (remove the inactive part of the log without making a backup copy of it), you could change the command to this:

DUMP TRANSACTION inventory WITH TRUNCATE_ONLY

For more information about truncating logs, see More About Backing Up and Restoring, later in this chapter.