Solved

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

Posted on 2013-06-18
3
313 Views
Last Modified: 2013-06-20
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
Comment
Question by:sg05121983
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Assisted Solution

by:Matt Bowler
Matt Bowler earned 125 total points
ID: 39258647
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
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 125 total points
ID: 39260063
Yes.  And if SQL produced any dump file(s), be sure to keep copies of it(them) as well.
0
 

Author Closing Comment

by:sg05121983
ID: 39264766
--
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question