Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Damon Wilson » SQL Server 2005 In-Place Upgrade Versions
Add to briefcase
17 posts, Page 2 of 2
««12

SQL Server 2005 In-Place Upgrade Versions Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Key DBA
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
jeepo1234
Posted Friday, March 28, 2008 9:19 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 1,982, Visits: 109
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
joshcsmith13
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: Tuesday, November 27, 2012 9:57 AM
Points: 502, Visits: 212
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
Key DBA
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
WILLIAM MITCHELL
Posted Friday, March 28, 2008 10:07 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:45 AM
Points: 1,441, Visits: 2,485
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
Mark D Powell
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: 2 days ago @ 12:26 PM
Points: 1,258, Visits: 341
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
L' Eomot Inversé
Posted Tuesday, January 04, 2011 3:08 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:07 PM
Points: 7,096, Visits: 7,156
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
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1042723
« Prev Topic | Next Topic »

Add to briefcase
17 posts, Page 2 of 2
««12

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.