Post reply

Following server reboot database is listed but doesn't seem to be Online

  • February 21, 2013 at 2:58 pm

    #270773

    I reboot Windows 2008 R2 server with SQL Server 2008 R2. When I open SSMS the database shows up in the database list but there is no + next to the database to allow expansion to see tables and other items. I right click and go to Tasks and the Bring Online is greyed out. If I take it offline then immediately Bring it online the expansion becomes available. Any Ideas why I am having to go through these extra steps of offline and online.

  • February 21, 2013 at 3:11 pm

    #1590148

    Anything in the SQL logs?

  • February 21, 2013 at 3:20 pm

    #1590151

    Execute and post the result:

    SELECT state_desc,is_auto_close_on

    FROM sys.databases

    WHERE name = 'DbName'

  • February 21, 2013 at 3:21 pm

    #1590152

    Nothing but the standard informational startup messages. No errors or warnings.

  • February 21, 2013 at 3:24 pm

    #1590153

    state_descis_auto_close_on

    ONLINE 0

Viewing 5 posts - 1 through 4 (of 4 total)

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