Post reply

Restore Master DB to Another Server

  • July 18, 2007 at 9:21 am

    #117781

    We've encountered problems restoring a master database to another server.  Microsoft documentation indicates this can be done through Management Studio, but we were unsuccessful.  We were able to set the server in Single User mode and restore the master using sqlcmd. 

    In SQL 2000 all user databases would be marked as "suspect" after restoring master to another server.  In 2005 we see the databases (not marked as suspect), but cannot access them because they have yet to be restored.  Shouldn't the databases be marked as "suspect" in 2005 just like in SQL 2000?

    Also, we are unable to restore the user databases through Management Studio or a Query window.  We are running SQL Server 2005 EE - SP1.  Are we seeing a bug or is the MS documentation incorrect for recovering master in 2005?

    Thanks,   Dave

  • July 18, 2007 at 6:43 pm

    #720589

    sql 2005 doesnt show the suspect status in the object expplorer......,try this but i am not sure....

    select databasepropertyex('DBName','Status') ..............

    whats the error you get while restoring the user dbs ? ? ?

    [font="Verdana"]- Deepak[/font]

  • July 18, 2007 at 9:25 pm

    #720603

    That's a feature they should have kept in 2005.  They should be working to simplify troubleshooting efforts rather then add complexity.

    I'll recreate the error next week to document the problem.  We created a screen-shot of the error and moved on due to a DR test.

    Thanks,  Dave

  • July 19, 2007 at 3:09 am

    #720652

    Yes Dave i do agree few things in 2005 are complicated rather than being simplified. One such example is the log shipping role change thati have already pointed out. I am not sure if MS does this knowingly or unknowingly.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 19, 2007 at 8:24 am

    #720796

    'knowingly or unknowingly'... what scares me is what were the problems they avoided with the solution they provided?

    As if you needed another reason to lose sleep....

  • July 23, 2007 at 1:59 am

    #721449

    I don't think so they have avoided any problems. Infact we are doing some few things for extra time.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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