Home Forums SQL Server 2008 SQL Server 2008 - General Restore master db from sql 2000 to sql 2008 R2 RE: Restore master db from sql 2000 to sql 2008 R2

  • May 14, 2012 at 12:53 pm

    #1487334

    ScottPletcher (5/14/2012)

    You should be able to restore the master db to a different db name, if you want to pull data from the old master db directly in the SQL 2008 instance.

    however updating the system tables is no longer possible. you cant just change the GUID of a user by updating the corresponding table. was a great undocumented feature that went away since it was also very easy to screw things up if you were not very careful.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]