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 1 of 2
12»»

SQL Server 2005 In-Place Upgrade Versions Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Key DBA
Posted Thursday, March 27, 2008 9:14 PM
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
Comments posted to this topic are about the item SQL Server 2005 In-Place Upgrade Versions

"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
Post #475862
Robert-378556
Posted Friday, March 28, 2008 3:26 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:40 AM
Points: 1,078, Visits: 847
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.
Post #475930
Derek Dongray
Posted Friday, March 28, 2008 4:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:04 AM
Points: 1,342, Visits: 1,946
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
Post #475979
Buxton69-502449
Posted Friday, March 28, 2008 5:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 19, 2009 8:32 AM
Points: 196, Visits: 465
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.
Post #475982
Robert-378556
Posted Friday, March 28, 2008 5:54 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:40 AM
Points: 1,078, Visits: 847
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.
Post #476013
Jeff Deluca
Posted Friday, March 28, 2008 6:18 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 31, 2011 2:32 PM
Points: 491, Visits: 221
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.
Post #476024
Key DBA
Posted Friday, March 28, 2008 6:48 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
Sorry about the confusing wording everyone. I will get future questions proofed more before submission.

"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
Post #476049
Cliff Jones
Posted Friday, March 28, 2008 7:52 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:11 PM
Points: 3,390, Visits: 3,403

Poorly worded or not, I would never do an in-place upgrade.
Post #476107
mtassin
Posted Friday, March 28, 2008 8:18 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 4:59 AM
Points: 3,226, Visits: 64,063
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
For tips on how to post your problems
Post #476130
Derek Dongray
Posted Friday, March 28, 2008 8:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:04 AM
Points: 1,342, Visits: 1,946
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
Post #476154
« Prev Topic | Next Topic »

Add to briefcase
17 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

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