Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Downgrade from SQL Server 2008 enterprise edition to Developer edition Expand / Collapse
Author
Message
Posted Monday, February 24, 2014 9:43 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 11:04 AM
Points: 299, Visits: 1,122
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
Post #1544762
Posted Monday, February 24, 2014 10:34 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1544769
Posted Monday, February 24, 2014 10:41 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1544770
Posted Wednesday, February 26, 2014 3:00 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 4:18 AM
Points: 2,886, Visits: 3,256
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1545286
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse