How to repair a SQL Server "Suspect" database
Check DB
Sometimes when you connect to your database
server, you may find it in suspect mode. Your
database server won’t allow you to perform any operation on that database until
the database is repaired.
A database can go in suspect mode for many reasons
like improper shutdown of the database server, corruption of the database files
etc.
To get the exact reason of a
database going into suspect mode can be found using the
following
Leggi tutto il post...