Solved

how to find this error message in log file for MS SQL2008

Posted on 2011-02-11
2
216 Views
Last Modified: 2012-06-21
I received a alert from MS SQL 2008

The alert is about

Database state change: ****



Server : xxx

Alert Level : High

Occurred at : 2/9/2011 2:04:08 PM

Description : State change to database *** on xxx

More details for Server: xxx\*** -....


I could not find it in the log file, do you know where it's located and explain it what it possible is about

and I want to know if I can find this error message by querying the log file. what is the standard query?
0
Comment
Question by:wasabi3689
[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
  • 2
2 Comments
 
LVL 12

Accepted Solution

by:
NormanMaina earned 125 total points
ID: 34874421
SQL Server 2005 offers an undocumented system stored procedure sp_readerrorlog.  Check if it work with 2008
http://www.mssqltips.com/tip.asp?tip=1476
0
 
LVL 12

Assisted Solution

by:NormanMaina
NormanMaina earned 125 total points
ID: 34874438
The other way to view the SQL Server error log :
-In Object Explorer, expand a server, expand Management, and then expand SQL Server Logs
-Right-click a log and click View SQL Server Log

Then you can filter as you wish
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL syntax question 6 67
Database Mail Profiles 1 44
Need to trim my database size 9 48
Please explain the difference between EXCLUDE, INTERSECT and JOIN 7 47
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

740 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