Alfred's New Ramblings

SQL Database showing Suspect.

I got a call saying one of the SQL database was unable to connect.  In the management studio (SQL 2008), the database is flagged as “Suspect”

Microsoft suggests looking at the SQL server error log.  All it says was connection was lost, the store and/or transaction log may be corrupted.  Restore from latest backup etc.

There was no backup available for this database.  So I am stuck.  Viewing properties generated an error.  User security can displays only the other databases, with a prompt saying database unavailable not displayed.

Noodling, got this fantastic guide.

Tagged on:

Leave a Reply

Your email address will not be published. Required fields are marked *