February 24, 2014 at 9:43 pm
I need to downgrade SQL server 2008 enterprise edition to developer edition on our test systems. I'm planning to implement this using side by side migration.
Could someone please let me know if the following steps are correct?
(1) Run DBCC CheckDB on all the user and system databases
(2)Backup prod and sys databases
(3) Script out all the logins, jobs, linked servers etc
(4) Install SQL Server 2008 developer edition as the named instance
(5) Restore all the sys and prod database backups
(6) Run the logins, jobs scripts which were taken previously.
(7) Uninstall the default instance(Enterprise edition)
(8) Rename the named instance to default instance
February 24, 2014 at 10:34 pm
I don't think you will be able to rename named instance.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 24, 2014 at 10:41 pm
Also you can do Detach/Attach of the databases which will be easier and faster.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 26, 2014 at 3:00 am
It is worth looking at your Microsoft Licensing terms. You may able to install Enterprise in non-production environments under the MSDN provisions for no charge. In this situation you can leave things as they are and save a shedload of time.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply