Step 2: Schedule a full backup for each Tuesday and Friday at 2:00 A.M.

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 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	Select to append the backup to any existing backup on the backup device.
   Overwrite existing media	Select to overwrite any existing backups on the backup device.

9. In the Schedule, select Schedule, and click .
10. In the Edit Schedule dialog box, do the following:

    Use this	To do this
    Name	Type CSFullSch.
    Schedule type	Select Recurring, and then click Change.

11. In the Edit Recurring Job Schedule dialog box, do the following:

    Use this	To do this
    Occurs	Select Weekly.
    Weekly	Select the Tue and Fri check boxes.
    Daily frequency	Select Occurs once at, and then type 2:00:00 AM.

12. Click OK three times to close all of the dialog boxes.

Copyright © 2005 Microsoft Corporation.
All rights reserved.