Solved

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

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS Parameters 10 24
SQL Server Results to Excel File 18 73
What is the best way to use power bi and ssrs 3 44
SSRS 2008 Jump To Report 4 19
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…

685 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