1. Install and run SQL Management Studio to access the database.
2. Make a full backup of the database mentioned in the Description line of the error.
3. Stop all Milestone services that use this database.
4. Right-click the database and select Properties ? Options.
5. Scroll down the lower right-hand frame to find Restrict Access. Set this to Single User.
6. Click "OK." The database is now locked from any interaction from any service.
7. Select "New Query."
At this point you are ready to run checkdb or checktable depending on the error. In the query window, type the following for checkdb:
DBCC CHECKDB(<name of the database>, REPAIR_REBUILD);
Then click on the "Execute Query" button. SQL will then check and repair the database.
If the error refers to a specific table, then checktable may be necessary. Use the following syntax for checktable:
USE <name of the database>;
DBCC CHECKTABLE(<name of the table>, REPAIR_REBUILD);
Once complete, both queries will produce a report on the rows examined. After this, you need to put the database back into Multi-User mode by using the following steps:
1. Close the query tab.
2. Right-click the database, select Properties ? Options.
3. Scroll down the lower-right hand frame to find Restrict Access. Set this to Multi-User.
4. Click OK.
5. Restart your Milestone services.
You can also check this blog.
SQL Database Recovery Expert 🙂