November 25, 2003 at 9:51 pm
Hmm, "my" BOL says SQL 200 Personal Edition can be upgraded to 2000 Standard Edition, not Enterprise Edition. Is there somewhere else that shows upgrade paths that are different to BOL?
SJT
SJT
November 26, 2003 at 1:56 am
FYI
Quote from BOL sp3:
"Upgrading From One Edition to Another
These are the supported upgrade paths between the editions and versions of SQL Server 2000:
SQL Server 2000 Personal Edition to either SQL Server 2000 Enterprise Edition or SQL Server 2000 Standard Edition."
You can find the entire info in bol under "Editions of SQL Server 2000"
Fredrik
November 26, 2003 at 6:59 am
I agree with SJT, Microsoft's website states the same "SQL Server Personal Edition" can only be upgraded to "SQL Server 2000 Standard Edition". The same article states the correct answer as well about "Eval Edition" and the "Failover Cluster".
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_overview_2xtf.asp
November 26, 2003 at 8:48 am
Not that I've tried it, but at the very least you cannot say that Personal Edition cannot be upgraded to Enterprise edition. If Personal edition can be upgraded to Standard - Standard can still be upgraded to Enterprise.
Note that I still answered the question incorrectly =)
-Ken
November 26, 2003 at 8:50 am
I looked up the same BOL article but noticed it only had three of the six answers provided - and I noticed that the first one had been mis-copied into the answer text!
I ended up finding the Eval edition to Enterprise upgrade path was valid from MS's web site. I could not find anything specific on upgrading an Eval Ed. failover cluster BUT I did find out that failover clustering is supported in the Eval Edition as well as upgrading to Enterprise Edition...so doesn't that mean that a failover cluster can be upgraded??
Though I have great respect for those who run this site, I often feel like I am playing "guess what's on my mind?" with the QOD's.
November 26, 2003 at 8:52 am
quote:
Though I have great respect for those who run this site, I often feel like I am playing "guess what's on my mind?" with the QOD's.
It's just a testament to your mad SQL Server skillz.
I generally enjoy getting the questions wrong more so than getting them right - it proves to me that there is still something else for me to learn.
Edited by - spongemagnet on 11/26/2003 08:54:28 AM
-Ken
November 26, 2003 at 10:02 am
I found the answer here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8ynn.asp
Upgrading From One Edition to Another
These are the supported upgrade paths between the editions and versions of SQL Server 2000:
SQL Server 2000 Personal Edition to either SQL Server 2000 Enterprise Edition or SQL Server 2000 Standard Edition.
SQL Server 2000 Standard Edition to SQL Server 2000 Enterprise Edition.
SQL Server 2000 Desktop Engine to SQL Server 2000 Enterprise Edition or SQL Server 2000 Standard Edition.
SQL Server 2000 Enterprise Evaluation Edition to SQL Server 2000 Enterprise Edition, SQL Server 2000 Standard Edition, SQL Server 2000 Developer Edition, or SQL Server 2000 Personal Edition. SQL Server 2000 Enterprise Evaluation Edition upgrades are not supported in failover clusters.
January 8, 2004 at 12:54 am
I TRULY hope the MCDBA exam questions aren't as ambiguous as these!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply