Share via

Step 1: Perform a full backup of the Commerce Server database

  • Article

To create a full backup of the Commerce Server <site name>_commerce database

  1. In SQL Server Enterprise Manager, expand a server group, and then expand a server.
  2. Expand Databases, right-click the database you want to back up, point to All Tasks, and then click Backup Database.
  3. In the SQL Server Backup dialog box, do the following:
    Use this To do this
    Name Type Full-<current date: mmddyy> for the backup set name.
    Description Type Full backup of the Commerce database as a description for the backup set.
    Backup Select Database - complete.
  4. In the Destination section, click Add to add a backup device.
  5. In the Select Backup Destination dialog box, select File name, and then click the ellipsis to select the backup destination file.
  6. In the Backup Device Location dialog box, in the File name box, type CommFull, and click OK.
  7. Click OK to close the Select Backup Destination dialog box.
  8. In the SQL Server Backup dialog box, in the Overwrite section, do the following:
    Use this To do this
    Append to media Append the backup to any existing backup on the backup device.
    Overwrite existing media Overwrite any existing backups on the backup device.
    Schedule Optionally, select to schedule the backup operation for later or periodic execution.
  9. Optionally, click the Options tab and select from these backup options:
    • Verify backup upon completion. Causes the backup to be verified when backed up.
    • Eject tape after backup. Causes the tape to be ejected when the backup operation has completed. Available only with tape devices.
    • Check media set name and backup set expiration. Causes the backup media to be checked to prevent accidental overwrites. In the Mediasetname box, type the name of the media that should be used for the backup operation. Leave blank when specifying only the backup set expiration date.
  10. If you are using the backup media for the first time, or if you want to change an existing media label, in the Media set labels section, select Initialize and label media, and type the media set name and media set description. (The media can only be initialized and labeled when overwriting the media.)

Copyright © 2005 Microsoft Corporation.
All rights reserved.