January 18, 2011 at 7:26 am
I found a database offline
This was the message in event viewer
Event ID: 5084
Setting database option OFFLINE to ON for database.
The database went offline by itself. Could this indicate a problem? Is there anything that I should check for?
January 18, 2011 at 7:42 am
The SQL Server Error Log and the System Event Log should have more information regarding this. Someone manually bringing the database OFFLINE is also a possibility.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
January 18, 2011 at 8:13 am
That doesn't sound like an error. That sounds like a statement put the database in an offline condition.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 18, 2011 at 8:45 am
This might be in the default trace. There is an event that shows the database name, the object of NULL and then a class of 164 when I bring it on/offline.
May 11, 2012 at 10:19 am
Hi,
Is it possible to track who and when the SQL database was made offline state.
Where we can able to check the events for the same?
I can able to see the events as database has been made to online state in the error log However, unable to track the events when it was made offline and how.
Thanks..
May 11, 2012 at 11:32 am
Not sure if this is what you're looking for, but you can set up a SQL Audit, and have a Server Audit Specification with an Audit Action Type of DATABASE_CHANGE_GROUP. This will audit an ALTER DATABASE command and you can view the statement text to see that it was a SET OFFLINE. You will also be able to see what principal executed the command, and a lot of other details.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply