Database State is Shwoing Offline

  • Dear All,

    Am Using SQL 2008,

    My Database State is shwoing as Offline,

    Please help me out ,Where can i check first and how to resolve this issue..

    Regards

    Jagadeesh....

    Regards
    Chowdary...

  • Right click database -> tasks -> bring online

    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
  • I'd also suggest checking the error logs to see if you can tell why the database is offline.

    "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

  • Well, Thank u all,

    Can you pls share what are the main reasons for that.what is the immediate actoin i have to take to recover that DB.

    If I select Online by right clicking on that DB,It is showing error again .

    Regards

    Jagadeesh....

    Regards
    Chowdary...

  • Chowdary's (5/26/2014)


    Can you pls share what are the main reasons for that.

    A database will go into the offline state if someone explicitly sets it offline. Errors cause other states

    If I select Online by right clicking on that DB,It is showing error again .

    And the error message would read.....????

    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 5 posts - 1 through 4 (of 4 total)

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