Creating a new Administration database
You need to roll back to a previous Administration database or create a new one, but you cannot reinstall Commerce Server. Running Commerce Server setup in Repair Mode does not accomplish this either.
Solution
Create a new database named MSCS_Admin and then run the file Admin_schema.sql on it using SQL Query Analyzer. A new Administration database is created. Running the script populates the schema of the Administration database but no resources are created.
To create a new Administration database
- Delete or rename your existing Administration database, if necessary.
- Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
- In Enterprise Manager, expand Microsoft SQL Servers, expand SQL Server Group, and then expand the name of the server on which you want to create the new Administration database.
- Right-click Databases, and then click New Database.
- In the Database Properties dialog box, on the General tab, in the Name box, type MSCS_Admin.
- Click OK.
Your new database is created. The next step is to run the Admin_schema.sql file.
To run the Admin_schema.sql file
- In Enterprise Manager, click the MSCS_Admin database.
- On the Tools menu, click SQL Query Analyzer.
- On the File menu, click Open.
- Browse to Program Files\Microsoft Commerce Server, select the Admin_schema file, and then click Open.
- On the Query menu, click Execute.
You will need to unpack your sites again and reinstall Direct Mailer and the Predictor resource using Commerce Server Setup.
Note
- Immediately after you install your site, and any time you change the configuration of your Commerce Server deployment, you should back up your Administration database using a different name. You can use this copy to roll back any changes that are made later.
Copyright © 2005 Microsoft Corporation.
All rights reserved.