It seems as though our last administrator has installed Enterprise Licenses (SQL 2005) We need these to be Standard, can I down grade some how with minimal to no disruption to our databases?
If so How, if not (which i almost positive that you are going to say NO) then i assume I am going to have to reinstall the SQL server. What is the best way going about this with out having to restore all of the databases? Can i copy all of the MDF and LDF files else where and then once the new installation has completed create the users, then databases and then replace the MDF and LDF?
Is there a better way then this if so it would be a huge help.
Thanks
Brad
I believe that it will be necessary to remove SQL Enterprise Edition and reinstall SQL Standard Edition. Enterprise Edition installs some supporting files that are not allowed with Standard Edition so you cannot simply 'downgrade' the license since you would still have the functionality.
Make a set of complete FULL backups, including master and msdb. Restore them after you have reinstalled Standard Edition. Or copy the mdf/ldf files, recreate any SQL Users, then ATTACH the databases.
|||Arnie Rowland is correct. Downgrading SQL Server Enterprise to other SQL Server SKUs is not supported.
No comments:
Post a Comment