Upgrading from SQL2000 to SQL2008 R2

  • Hi everone, hope everyone is in a good jolly mood 🙂

    Anyways, my situation is this:

    i am a newbie DBA here in our organization. the last dba guy was in the process of upgrading our dev, test and live from SQL 2000 to SQL2008 R2. he got to the initiating and plannin stage but for the execution stage he got to setup SQL2008 R2 for our devs and test servers. my question is how do i start this from where he left of?

    i tried studying the upgrade advisor because i know thats where i should start, right?

    thanks in advance for all your inputs!

    Cheers! 🙂
    [/url]

  • you have the two option to consider

    1) Inplace upgrade

    2) Side by side upgrade

    More detail is here

    http://www.sqlservercentral.com/articles/Upgrade/65872/

    ----------
    Ashish

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

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