Home Forums SQL Server 2012 SQL 2012 - General DB Offline RE: DB Offline

  • November 14, 2013 at 9:54 am

    #1666447

    crmitchell (11/14/2013)

    Could this have happened following a reboot of the Windows box hosting SQL Server?

    Only if, after the reboot, someone ran ALTER DATABASE <db name> SET OFFLINE.

    SQL will not set a DB offline. It can set a database recovering, recovery_pending or suspect, but offline is a status that is user-set.

    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