Post reply

Procedure to upgrade/migrate system databases from sql 2000 to sql 2005

  • January 5, 2010 at 5:46 am

    #136340

    Hello,

    Please send me the step by step process of the below mentioned activities.

    1- Procedure to upgrade system databases from sql 2000 to sql 2005.

    2 - Procedure to migrating system databases from sql 2000 to sql 2005.

    appreciate if you can share a word file or a link which clearly show this info.

    Rgds,
    Pankaj

  • January 5, 2010 at 5:52 am

    #1098873

    Why you want to upgrade/migrate system databases? Install SQL 2005 and upgrade/migrate your user databases.

  • January 5, 2010 at 5:58 am

    #1098876

    Yes, I'm only looking for the process to upgrade and migrate system databases.

    I want info like

    1 - what all are the pre-requisites

    2 - step-by-step process to accomplish.

    3 - any common challenges that might crop up etc....

    Rgds,
    Pankaj

  • January 5, 2010 at 6:02 am

    #1098881

    Don't try to migrate the system tables. Not recommended, not a good idea.

    If you're doing an in-place upgrade, the installer will take care of that. If you're doing another form of upgrade, script everything you need from master (logins, server permissions, linked servers) and script all your jobs and run those scripts on the new system databases.

    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

  • January 5, 2010 at 6:39 am

    #1098898

    Thanks GilaMonster. This is what I was looking for

    Rgds,
    Pankaj

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

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