Solved

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

Posted on 2011-02-11
2
209 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
  • 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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

708 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now