Post reply

cannot bring database back online

  • September 21, 2012 at 12:51 pm

    #262036

    i took the database offline to copy it, which i know now was un needed but now it wont let me bring it back online...

  • September 21, 2012 at 12:57 pm

    #1540915

    Please post exact error messages. Also check the SQL error log for more errors.

    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

  • September 21, 2012 at 1:01 pm

    #1540921

    ok if you are running a command like the one below, what error are you getting?

    Or is it you expect the SSMS object explorer to auto-refresh and not show the red icon (you have to manually refresh by clickign the database fodler...right click...refresh)

    -- Set the Database Online

    ALTER DATABASE [SandBox] SET ONLINE

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 3 (of 3 total)

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