[Webinar] Streamline your web hosting managementRegister Today

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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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