DB Offline

  • 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......."

  • Thanks Sreekanth. I had misinteptreted log entry "Offline to ON" as db has been made online :).

  • I figure this is sorted... but just check that auto close is not set to ON.

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply