KB00034: Restoring the MessageMaster Database
Description
Your SQL Server misbehaves, and you find that you have to re-install SQL or
even the entire OS to get it operational again. In the process, you lose or
are unable to restore the SQL 'master' database. Although you are able to
restore the MessageMaster database, you find that some settings have been
lost, such as database properties, permissions and full-text index. You
need to know what you need to put back in order for MessageMaster to work
again.
Resolution
We have a SQL script that will fix this very problem. You can download it
here.
The script will perform the following operations, leaving your data intact:
- set some database properties on the Objective Software database
- drop and re-add the full-text index
- re-create the database user, and set up its permissions on the Objective Software database
Before you run the script, you'll have to first perform several text
replace operations, so that the script will be tuned to your environment.
Near the top of the script:
- replace ObjectiveSoftwareDatabaseName with the name of your Objective Software database
- replace ObjectiveSoftwareDBUserName with the name of the database user that you previously set up to access the database. Be sure to use the same user name as before.
- replace ObjectiveSoftwareDBUserPassword with the password of the database user. Be sure to use the same password that you set up before.
When you're ready, you can proceed to run the script:
- open SQL Query Analyzer
- connect to the master database as sa or another fully privileged SQL account
- paste the entire contents of the script into the query area
- execute it
Applies To
