marrowyung
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 ?
"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 ?
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
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
ASKER
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 ?
"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 ?
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.
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.
ASKER
"You can script the user related objects."
for user login, I think we might add them back. probably easier !
for user login, I think we might add them back. probably easier !
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.
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.
ASKER
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?
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?
Yes.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?