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

Downgrading from Ent to Std Expand / Collapse
Author
Message
Posted Monday, August 06, 2012 9:42 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 12:58 AM
Points: 576, Visits: 1,532
Hi all

I was wondering if there was any decent articles on downgrading a SQL server from Ent to Std and what pit falls to be aware of.

Also how can I check if my existing server is using any Enterprise only features?

Thanks
Post #1340707
Posted Monday, August 06, 2012 11:56 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 03, 2013 2:11 PM
Points: 54, Visits: 349
Well, I would reccomend the following steps:
1.) Detach all existing databases, making a note of the physical file locations of all MDF, NDF, LDF & FilesStream objects.
2.) Uninstall SQL Enterprise.
3.) Reboot Server.
4.) Install SQL Standard.
5.) Attach all the databases.

That way takes some work, but you will know it's done right.
Post #1340797
Posted Monday, August 06, 2012 1:25 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:11 PM
Points: 3,081, Visits: 11,230
There is no direct downgrade from 2008 Enterprise Edition to Standard Edition, so you would have to do one of the following:
Setup a new server running Standard Edition, and migrate to that.
Uninstall Enterprise Edition on the current server and install Standard Edition.


Post #1340862
Posted Monday, August 06, 2012 1:44 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 12:58 AM
Points: 576, Visits: 1,532
Thanks for the replies - fair enough a bit of work required but should be ok. What is the best way to determine if the existing SQL Server is using any Enterprise only functions?
Post #1340874
Posted Tuesday, August 07, 2012 3:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 2:37 AM
Points: 5,075, Visits: 4,834
Query sys.dm_db_persisted_sku_features in each database, it will tell you what Enterprise features are being used.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1341082
Posted Tuesday, August 07, 2012 3:55 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 12:58 AM
Points: 576, Visits: 1,532
Hi and thanks. Unfortunately I am using SQL 2005 and this view doesn't seem to be supported grr...
Post #1341110
Posted Tuesday, August 07, 2012 4:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 2:37 AM
Points: 5,075, Visits: 4,834
Ah, you posted in the 2008 forum, so you got a 2008 answer.

I'm not aware of a 2005 equivilant, but you might find it on google or another search engine of your choice.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1341121
Posted Tuesday, August 07, 2012 4:23 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 12:58 AM
Points: 576, Visits: 1,532
So I did, google not my friend today am afraid.
Post #1341130
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse