April 2, 2012 at 2:42 pm
Hello There,
I have SQL2000 SP2 installed on my test machine and i want to perform upgradation to SQL2008. I had downloaded evaluation version of SQL2K8 and started upgradation but it stopped on "upgradae ruled" and gave me an error message (other rules passed)
"Rule SQL Server 2008 Feature upgrade failed, The specified edition upgrade is not supported. For information about supported upgrade paths, see the sql server 2008 version and edition upgrade matrix in books online. "
Is upgradation not supported in evalution version ?
April 2, 2012 at 3:00 pm
Here is the matrix listing the supported upgrades for SQL 2008.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 2, 2012 at 3:25 pm
SQLRNNR (4/2/2012)
Here is the matrix listing the supported upgrades for SQL 2008.
Where is the matrix? And I'm not talking about the movie(s). 😛
April 2, 2012 at 3:31 pm
Lynn Pettis (4/2/2012)
SQLRNNR (4/2/2012)
Here is the matrix listing the supported upgrades for SQL 2008.Where is the matrix? And I'm not talking about the movie(s). 😛
D'oh
http://msdn.microsoft.com/en-us/library/ms143393(v=sql.100).aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 3, 2012 at 11:45 am
Service pack of My current sql server 2000 is SP2 so to upgrade it to SQL2K8 it is must upgraded to SP4. I downloaded "SQL2000-KB884525-SP4-ENU.exe" to upgrade service pack of sql 2000 to SP4 from SP2.
To check whether it is upgraded to SP4, I check the version using "Select @@Version" but it still showing SP2 version.
Current version of sql server 2000 is as below:
Microsoft SQL Server 2000 - 8.00.2039 (Intel x86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service pack 2).
I checked the matrix and according to the information on MS site
SQL Server 2000 (32-Bit) Standard SP4 can be upgraded to SQL server 2008 Enterprise or SQL server 2008 Standard edition. but first requirement is to have SP4 on SQL 2000.
Is there any way or any setup that can upgrade service pack from SP2 to SP4 ?
April 3, 2012 at 11:51 am
jitendra.padhiyar (4/3/2012)
Service pack of My current sql server 2000 is SP2 so to upgrade it to SQL2K8 it is must upgraded to SP4. I downloaded "SQL2000-KB884525-SP4-ENU.exe" to upgrade service pack of sql 2000 to SP4 from SP2.To check whether it is upgraded to SP4, I check the version using "Select @@Version" but it still showing SP2 version.
Current version of sql server 2000 is as below:
Microsoft SQL Server 2000 - 8.00.2039 (Intel x86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service pack 2).
I checked the matrix and according to the information on MS site
SQL Server 2000 (32-Bit) Standard SP4 can be upgraded to SQL server 2008 Enterprise or SQL server 2008 Standard edition. but first requirement is to have SP4 on SQL 2000.
Is there any way or any setup that can upgrade service pack from SP2 to SP4 ?
Actually, you have upgraded SQL Server 2000 to sp 4, here is the build for it: 8.00.2039.
The service pack you see at the end, (Build 3790: Service pack 2), is for the OS, not SQL Server.
April 3, 2012 at 12:15 pm
Thanks Pettis..!
I again try to upgrade it.. but it stuck at SQL Server 2008 Feature upgrade.. I recieved an error message " Rule SQL Server 2008 Feature upgrade failed. The specified edition upgrade is not supported."
Is it because I am trying to upgrade SQL 2000 to SQL 2008 (evaluation version) ?
The setup of SQL 2008 is of evaluation version. So is it the cause of the error ?
April 5, 2012 at 2:51 pm
Hello guys,
Please revert me... I am doing in-place upgradation and still the same error confusing me.
" Rule SQL Server 2008 Feature upgrade failed. The specified edition upgrade is not supported."
April 5, 2012 at 3:51 pm
jitendra.padhiyar (4/5/2012)
Hello guys,Please revert me... I am doing in-place upgradation and still the same error confusing me.
" Rule SQL Server 2008 Feature upgrade failed. The specified edition upgrade is not supported."
If you are trying to upgrade to 2008 Evaluation edition, that is the cause of the error. If you take another look at the matrix I provided, the only editions of 2008 you can upgrade to are Standard and Enterprise.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply