question

Seventy7 avatar image
Seventy7 asked

How to fix a database marked as suspect

I have a database that I haven't checked on for about a week but it contains critical data. Now when I try to log on to it, I just get the name of the database and (suspect).

Please explain what has happened and how to open it again.

Thanks in advance.

sql-serversuspect
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Melvyn Harbour 1 avatar image
Melvyn Harbour 1 answered

A good summary of how to fix this sort of problem is available in this article by Barry:

http://www.sqlservercentral.com/articles/Administration/unmarksuspect/137/

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

hodkinss avatar image
hodkinss answered

Sometimes (and depending on your version and what happened to cause it to go suspect)it helps to stop and start the services. Stop first MSSQLServer and then SQL Server Agent. Then restart the services in reverse order.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.