Step 4: Schedule differential backups for every day at noon and midnight

To create a differential 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 Differential<current date: mmddyy> for the backup set name.
   Description	Type Differential backup of the Commerce database as a description for the backup set.
   Backup	Select Database - differential.

4. In the Destination section, click Add to add an existing backup device or to create a new backup device.
5. 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.

6. In the Schedule section, select Schedule, and click .
7. 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.

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

   Use this	To do this
   Occurs	Select Daily.
   Daily frequency	Select Occurs every,and then type 12 hours.

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

Copyright © 2005 Microsoft Corporation.
All rights reserved.