Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Server 2005 In-Place Upgrade Versions Expand / Collapse
Author
Message
Posted Friday, March 28, 2008 8:38 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 26, 2009 3:02 PM
Points: 515, Visits: 655
Derek,

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

Regards,



"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
Post #476158
Posted Friday, March 28, 2008 9:19 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:50 AM
Points: 1,986, Visits: 120
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



Post #476196
Posted Friday, March 28, 2008 9:24 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 11:39 AM
Points: 509, Visits: 246
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.


Post #476200
Posted Friday, March 28, 2008 9:47 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 26, 2009 3:02 PM
Points: 515, Visits: 655
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
Post #476233
Posted Friday, March 28, 2008 10:07 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 5:23 AM
Points: 1,522, Visits: 2,731
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.
Post #476260
Posted Friday, March 28, 2008 11:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 1:55 PM
Points: 1,390, Visits: 409
I agree the use of the word "only" means the statement precludes any of the other answers from being chosen at all.

I got it right but I assumed that the author just choose poor wording and made the choice as follows

7.0 SP4 is valid
2K SP3 + is valid
2K SP4 would be included in SP3 and up
that left 2005 RTM considering applying SP1 or SP2 as in place upgrade.

I was worried that the author wanted the first choice to be wrong because you are already on 200t but because the RTM was there I figured he or she was looking for applying the SP.

Half the questions posted here are unclear and require too many assumptions.

Just my opinion
-- Mark D Powell --
Post #476324
Posted Tuesday, January 4, 2011 3:08 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:21 PM
Points: 7,928, Visits: 9,653
I mistakenly read the possible answers as meaning what they said, which clearly meant that neither of the two containing the word "only" could be correct as if one of them then only that one and the 2005 RTM could be allowed (anything else would contradict "only") which wouldn't allow 3 correct answers. That forced the choice to be the other three answers, which of course is not correct. Terrible phrasing!

Tom
Post #1042723
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse