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

1. Delete or rename your existing Administration database, if necessary.
2. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
3. 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.
4. Right-click Databases, and then click New Database.
5. In the Database Properties dialog box, on the General tab, in the Name box, type MSCS_Admin.
6. 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

1. In Enterprise Manager, click the MSCS_Admin database.
2. On the Tools menu, click SQL Query Analyzer.
3. On the File menu, click Open.
4. Browse to Program Files\Microsoft Commerce Server, select the Admin_schema file, and then click Open.
5. 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.