Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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