|
|
| |
My database has been marked suspect. How can I fix this?
Answer:
A database can be marked suspect for one of the following reasons
(this is from SQL Server Books Online):
If one or more database files are not available.
If the entire database is not available.
If one or more database files are corrupted.
If a database resource is being held by the operating system.
|
To resolve a suspect status, you can use the sp_resetstatus stored procedure.
This is the example to turn off the suspect status on the pubs database:
sp_resetstatus pubs
Read about the sp_resetstatus stored procedure in SQL Server Books Online.
|
|
|
