SQL 2005 Enterprise to SQL 2005 standard

Dear all,

As SQL server 2005 Enterprise can't change to SQL server 2008 R2 standard.

how about SQL server 2005 Enterprise edition downgrade to SQL 2005 standard edition, doable ?

they both different machine, can the system and user databse backup and restore to it ?

we will then try to ugprade the SQL server 2005 standard to SQL server 2008 R2 standard.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
 
Mark WillsConnect With a Mentor Topic AdvisorCommented:
No, going from Enterprise to Standard is not supported as an upgrade - not even if the new one is a later version (like SQL 2008, SQL 2008R2, SQL 2012).

Or, to think of it a different way, "downgrading" is not supported as you would like.

Please see : http://msdn.microsoft.com/en-us/library/ms143393(v=sql.90).aspx and note on the left hand side there is no entry for 2005 Enterprise.

Then have a look at 2008R2 upgrades : http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx and notice on the left hand side the entries for 2005 Enterprise and your supported upgrades are SQL 2008R2 enterprise and higher.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
yeah, you are right !  I told my boss about that after sending this ticket.

So, one thing, as SQL server 2005 is need to install at least SP3 in order to run on Windows 2008 R2 enterprise editon.

what if our new server runs on Windows 2008 R2 enterprise as 2 x nodes clusters, and then we instlal the SQL server 2005 RTM on it, then upgrade it to SP4.

Question is :
1) we can do the upgrade directly from RTM to SP4, right?
2) our old server still using a mix of SQL server 2005 SP2 and RTM edition, can the system DB backup and restore from RTM and SP2 to the new SP4 machien.

Waht we discussed is the built number is different, then system DB can't backup and restore to the other server, right?
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
mark_wills:

"how about SQL server 2005 Enterprise edition downgrade to SQL 2005 standard edition, doable ?

they both different machine, can the system and user databse backup and restore to it ?"

waht I also asking is can we on the new mahcine install SQL srever 2005 stnadar edition, but restore the sytem and user database from the SQL server 2005 Enterprise edition in the existing old machine ?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Mark WillsTopic AdvisorCommented:
We always used to say... Once on Enterprise, always on Enterprise...

You cannot easily go from Enterprise to Standard. If you havent used any Enterprise features, you might have some more joy, otherwise, you might need to use Copy Database Wizard.

System databases will not restore on a different version. It does need to have the same build number to be sure.

You can install your current version, but it will need to be upgraded to at least SP3 as the first step after install. Please read : http://support.microsoft.com/kb/955725

Also read : http://support.microsoft.com/kb/973993 for the /passive switch
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
mark_wills,

"You cannot easily go from Enterprise to Standard. If you havent used any Enterprise features, you might have some more joy, otherwise, you might need to use Copy Database Wizard."

Copy database wizard can't copy system database: http://msdn.microsoft.com/en-us/library/ms188664(v=sql.90).aspx

I am not sure if this one, http://support.microsoft.com/kb/973993, apply to SP4 also ?
0
 
Mark WillsTopic AdvisorCommented:
No, system databases are quite special and cannot be simply copied or restored onto your new version.

You can script the user related objects.

Dont think it does relate to SP4, more so, I was mentioning that you do need to be on a higher SP than SP2. Always recommend that the latest Service Packs be applied.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
"You can script the user related objects."

for user login, I think we might add them back. probably easier !
0
 
Mark WillsTopic AdvisorCommented:
Yep...

As I have always said - I personally have not had too much joy scripting things, and always found it better to review and recreate.

But there are others who do script and they seem to have had more success than I have.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
we have no choice here.

right now i have another project.

SQL Server 2005 upgrade from RTM/SP2 to SP4, I have to upgrade 3 x during tomorrow and day after tomorrow.

the steps should be the same as upgrading SP2, rihgt?
0
 
Mark WillsTopic AdvisorCommented:
Yes.
0
 
Eugene ZConnect With a Mentor Commented:
yes - the same steps - just make sure server is ok: no errors ; no heavy transactions' running jobs ; have free space on the drives , no users using system - and do not forget to reboot after
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.