November 20, 2013 at 8:01 am
Why do you need exact syntax here?
It wont give you exact T-SQL and i don't think it's needed in your case. If it says Type as "database" and DDL Operation as ALTER in the report, then some one ran ALTER Database stmnt. And it also gives you exact time and the Login Name in this report. Now you can verify in your error logs at the exact same time, it logs something similar to "Setting database Option Offline to ON for database......."
November 24, 2013 at 11:43 pm
Thanks Sreekanth. I had misinteptreted log entry "Offline to ON" as db has been made online :).
November 26, 2013 at 5:46 am
I figure this is sorted... but just check that auto close is not set to ON.
November 26, 2013 at 6:48 am
Zksod (11/26/2013)
I figure this is sorted... but just check that auto close is not set to ON.
Autoclose doesn't set the database to the OFFLINE state. A database closed by Auto_Close remains in the ONLINE state and just has the is_cleanly_shutdown column set to 1 in sys.databases.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply