I have a Cisco Unity v4 server, with MSDE installed. Unity will not start. I checked the SQL Database and found that the UnityDb Database is suspect. I am unable to find a way to repair this.
SQL will mark a database as suspect if it is unable to access the database. You can try to reset the status of the database, but if it comes back as suspect, then the database is corrupt. If you have a backup you should be able to restore the backup, otherwise you can try to reset the status of the database.
1) The first thing to do is verify that you have free space on the server. A database can be marked suspect if SQL cannot complete recovery on a database because there is not enough free space. If there is adequate space on the hard drive, proceed to the next step.
2) Open Query Analyzer
3) Connect to the server
4) In the query window, enter the following and execute it:
* Use master
5) Exit Query Analyzer
6) Restart the MSSQLSERVER service.
7) Check the status of the database.
if this helps, please rate