Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

If SQL SERVER 2008 server has crashed and then restored, which event viewer /log file/system monitor(s) will the information about crash?

All,

MS SQL DB 2008 has been crashed which I am suspecting due to memory over flow.

Now it is restored but pls let me know which log/Monitoring tool would best describe the scenario of the crash ?
0
sg05121983
Asked:
sg05121983
2 Solutions
 
Matt BowlerDB team leadCommented:
I would look in the application and system logs of the eventvwr, and look at the SQL Server error log from just before the crash.
0
 
Scott PletcherSenior DBACommented:
Yes.  And if SQL produced any dump file(s), be sure to keep copies of it(them) as well.
0
 
sg05121983Author Commented:
--
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now