[dba-SQLServer] Suspect database

I have had this happen several times.  In my case it usually means that the server lost power as it 
was writing to a table.  In most cases that table was lost but the others were still there.

John W. Colby
www.ColbyConsulting.com


Arthur Fuller wrote:
> What does it mean when a database is identified in SSMS as suspect? One
> thing it means is that I can't open it. What is not clear is why the db was
> identified as suspect. Bad backup/restore? I have no idea.
> Arthur
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>