Restore the Commerce Server 2002 Databases
This topic explains how to restore the Commerce Server 2002 Starter Site databases that you backed up earlier in the walkthrough.
To restore the Commerce Server 2002 Databases
In SQL Server, right-click Databases, and then click Restore Database.
In the Restore Database dialog box, click From Device, and then click the ellipsis button […] to locate the Commerce Server 2002 Starter Site databases that you previously backed up.
For more information, see Back Up Commerce Server 2002 Starter Site Code and Data.
In the Specify Backup dialog box, click Add to add the CS2002StarterSite_BDPermissions database backup to the Backup location list, and then click OK.
Select CS2002StarterSite_BDPermissions in the Select the backup sets to restore list.
In the To database drop-down list, select the CS2002StarterSite_BDPermissions database.
In the Select a page dialog box, click Options, select Overwrite the existing database, and then click OK.
Repeat this process to restore each Commerce Server 2002 Starter Site database that you have backed up.
Restore the archived analysis database that you previously backed up.
For more information, see Back Up Commerce Server 2002 Starter Site Code and Data. For more information about how to back up SQL Server databases, see Archiving and Restoring Databases on the SQL Server Web site.