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 6, 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: Yesterday @ 7:56 AM
Points: 598, Visits: 1,628
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 6, 2012 11:56 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 3, 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 6, 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: Friday, October 3, 2014 2:23 AM
Points: 3,108, Visits: 11,503
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 6, 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: Yesterday @ 7:56 AM
Points: 598, Visits: 1,628
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 7, 2012 3:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:42 AM
Points: 5,216, Visits: 5,111
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 7, 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: Yesterday @ 7:56 AM
Points: 598, Visits: 1,628
Hi and thanks. Unfortunately I am using SQL 2005 and this view doesn't seem to be supported grr...
Post #1341110
Posted Tuesday, August 7, 2012 4:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:42 AM
Points: 5,216, Visits: 5,111
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 7, 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: Yesterday @ 7:56 AM
Points: 598, Visits: 1,628
So I did, google not my friend today am afraid.
Post #1341130
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse