Step 3: Schedule a transaction log file backup every 30 minutes

To schedule a backup for the Commerce Server database transaction log file

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, and click Properties.
3. In the <database> Properties dialog box, on the Options tab, in the Recovery section, from the Model drop-down list, select Full, and then click OK.
4. In the console tree, expand Management, right-click Backup, and then click Back up a database.
5. In the SQL Server Backup dialog box, do the following:

   Use this	To do this
   Database	From the drop-down list, select Commerce.
   Name	Type CommerceLog.
   Description	Type Commerce transaction log.
   Backuptype	Select Transaction log.
   Destination	Click Add to open the Select Backup Destination dialog box.

6. In the Select Backup Destination dialog box, select Backup device, and then from the Backup device drop-down list, select <New Backup Device>.
7. In the Backup Device Properties – New Device dialog box, in the Name box, type CSLog, and then click OK.
8. In the Select Backup Destination dialog box, click OK to return to the SQL Server Backup dialog box.
9. In the SQL Server Backup dialog box, select Overwrite existing media,****select Schedule, and then click .
10. In the Edit Schedule dialog box, do the following:

    Use this	To do this
    Name	Type CSTransLogSch.
    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 Daily.
    Daily frequency	Select Occurs every, and then use the drop-down lists to select 30 minutes. Note You must select the unit (minutes) before you can set the quantity (30), because the default unit is hours, which has a maximum value of 24.

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

Copyright © 2005 Microsoft Corporation.
All rights reserved.