SQL Server 2005 In-Place Upgrade Versions

  • Comments posted to this topic are about the item SQL Server 2005 In-Place Upgrade Versions

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • Yet another poorly worded question.

    You can't use "SQL Server 2000 SP 3 or later" or other older versions to upgrade to

    SQL Server 2005.

    You use "SQL Server 2005" to upgrade from older versions.

  • Actually, I thought it was poorly worded in a different way.

    To me, the phrase "Only SQL Server 2000 SP3 or later" implies that SQL Server 2000 SP4 is included. So if you tick SP3, you must tick SP4. Presumably if there's a SQL Server 2000 SP5 it will also be included.

    And if you are already running SQL Server 2005 RTM, then you can't "upgrade" to SQL Server 2005 because you already have it.

    So since the question asked for 3 answers, I decided they had to be the middle 3.

    Derek

  • Poor wording made it into a trick question when it was so simple, I got it wrong by the way in the same way as the above comment.

  • Derek Dongray (3/28/2008)


    Actually, I thought it was poorly worded in a different way.

    To me, the phrase "Only SQL Server 2000 SP3 or later" implies that SQL Server 2000 SP4 is included. So if you tick SP3, you must tick SP4. Presumably if there's a SQL Server 2000 SP5 it will also be included.

    And if you are already running SQL Server 2005 RTM, then you can't "upgrade" to SQL Server 2005 because you already have it.

    So since the question asked for 3 answers, I decided they had to be the middle 3.

    This was my first thought. If it's so poorly worded, I guessed "3 answers" is a trick since you can't upgrade 6.5 and assumed the other way, concluding that you can only use sqlserver2005 to upgrade anything to sqlserver2005.

  • Definitely a poorly worded question. In addition to the reasons stated above, why would you have 'version(s)' and (choose 3) in the same sentence. :hehe:

  • Sorry about the confusing wording everyone. I will get future questions proofed more before submission.

    :blush:

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • Poorly worded or not, I would never do an in-place upgrade.

  • Cliff Jones (3/28/2008)


    Poorly worded or not, I would never do an in-place upgrade.

    Ain't that the truth...

    Of course

    SQL Server 2005 RTM or later, Only SQL Server 2000 SP 3 or later, SQL Server 7.0 SP 4 or later

    The middle choice excludes the other two. Only is a very powerful word.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • A better way to ask the question would have been...

    Which of the following cannot be upgraded the SQL Server 2005:

    O SQL Server 2005 RTM

    O SQL Server 2000 SP4 or later

    O SQL Server 2000 SP3 or later

    O SQL Server 7.0

    O SQL Server 6.5

    Bu perhaps it would then have been too easy.

    Cliff Jones (3/28/2008)


    Poorly worded or not, I would never do an in-place upgrade.

    And, of course, the first thing to do when planning an upgrade is look at the release notes and see what the prerequisites are so this question is a bit academic.:D

    Derek

  • Derek,

    Thanks for the feedback. Great reminder about referencing the release notes.

    Regards,

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • Foolish Question, bad answers. Typical.

    2000 SP3 and later, and 7 sp4 and later work. They mark 2005 wrong (of course you can upgrade it, from std to enterprise for example) and you sure can upgrade 2000 SP4.

    AW

  • maybe I'm just dense, but I've reread the question 5 times, looked at the answers, and I still don't get what the "correct" answer was supposed to be. ?? I picked the middle 3 and got it wrong.

  • Josh,

    I was researching the different methods of upgrading to SQL Server 2005. The question I ended up writing (poorly, much to my embarrassment) came from the "SQL Server 2005 Upgrade Technical Reference Guide". which can be found at:

    http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

    This is a downloadable Word document.

    From Page 17/360:

    Versions

    For an in-place upgrade, SQL Server 2005's Setup program will require that you have certain versions of either SQL Server 2000 or 7.0. Specifically, you can use the in-place method provided by SQL Server 2005 Setup to directly upgrade the following versions:

    • SQL Server 7.0 Service Pack 4 (SP4) or later

    • SQL Server 2000 SP3, SP4, or later

    • SQL Server 2005 RTM or later

    If you migrate the databases yourself by using a side-by-side upgrade method, you can upgrade earlier versions of SQL Server 2000 or SQL Server 7.0. (SQL Server 6.5 databases and instances cannot be directly upgraded and must be manually upgraded.)

    The overall goal of the QOD was to let others know about the existence of the SQL Server 2005 Upgrade Technical Reference Guide so that they can better prepare for upgrades to SQL Server 2005.

    Missions Accomplished!

    (Just not how I anticipated it coming to fruition.)

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • The answer "SQL Server 2005 RTM or later " is not correct because it does not state which edition of 2005 RTM is installed, or which edition is replacing it. The referenced document spells out which specific 2005 editions can be upgraded to other 2005 versions.

Viewing 15 posts - 1 through 15 (of 17 total)

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