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 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
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: Today @ 5:15 AM
Points: 1,252, Visits: 917
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
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, October 20, 2014 5:17 AM
Points: 1,274, Visits: 1,985
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
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
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: Today @ 5:15 AM
Points: 1,252, Visits: 917
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
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: Thursday, September 25, 2014 7:31 AM
Points: 491, Visits: 225
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
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
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: Thursday, October 16, 2014 11:48 AM
Points: 3,965, Visits: 3,644

Poorly worded or not, I would never do an in-place upgrade.
Post #476107
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: Tuesday, September 30, 2014 7:42 AM
Points: 3,688, Visits: 72,435
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
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, October 20, 2014 5:17 AM
Points: 1,274, Visits: 1,985
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 12»»

Permissions Expand / Collapse