Improve company productivity with a Business Account.Sign Up

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

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

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
wasabi3689
Asked:
wasabi3689
  • 2
2 Solutions
 
Norman MainaCommented:
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
 
Norman MainaCommented:
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
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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