Moving the MMS Logging Database (4.7)

Summary:

MMS Release 4.7 by default uses MSDE (Microsoft Data Engine) to store logging information in an SQL 7.0 database. By default, the SQL database files are created in a folder called Log in the MMS installation folder.

Details:

The MMS 4.7 installation program installs MSDE on your computer if necessary, but MSDE does not include a management interface.

Resolution:

To move the logging database to a folder other than the MMS installation folder, you can either:

• install Microsoft SQL Server 7.0 from the Microsoft distribution CD to add the management interface. You can then use the SQL management tools to detach and reattach the logging database files. (Please view the attached .htm file for detailed instructions.)

• download and run the attached .bat file to move the log db (Please open the bat file for editing before running it to review what it will do.)