question

DonnaSQL2014 avatar image
DonnaSQL2014 asked

SQL Server Crashed

Hi Everyone, My SQL Server crashed and when I brought it back up it appeared to be fine. I'd like to know if there is any kind of diagnostics that I can run on it to make sure it is in good working order. I'm going to run the integrity check but is there more I can do. Thank you so much.
sql-server-2008-r2
1 comment
10 |1200 characters needed characters left characters exceeded

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

What do you mean by crash? Did the service stop running, Windows reboot, SQL become unresponsive etc? A good start would be the SQL error logs (access via SSMS). Then I would also check out the Windows Event logs (application and system).
1 Like 1 ·

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
You should run consistency checks on all the databases. DBCC CHECKDB()
10 |1200 characters needed characters left characters exceeded

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.