Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a client that has a recently expired SQL Server 2008r2 Enterprise Evaluation edition. I've been tasked to get it licensed and running SQL Server 2008 r2 Standard. How can I achieve this?

share|improve this question
add comment

1 Answer

You have to install SQL Server 2008 r2 Standard edition side by side (if you want to do it on the same server) and then move the database using backup/restore method.

Below is an outline of what needs to be done (if you want to do it on the same server without installing a side by side SQL 2008R2 instance).

  • backup all database on Enterprise Edition & script out the logins as well.
  • uninstall Enterprise Edition
  • install Standard Edition
  • Patch it to latest SP
  • restore databases
  • Create logins and map orphan users (if any).

Also, Unless you're using Enterprise-only features, you should be able to use detach and attach method from Enterprise to Standard.

Refer to answer by Jonathan here.

Also, refer to this approach with scripts... BUT WITH EXTREME CAUTION !! ... it uses detach/attach method and if you are using any enterprise features (which wont work in Standard edition) then the attach wont work.

Also, refer to Version and Edition Upgrades Matrix.

share|improve this answer
    
Note that Enterprise-only features still come into play with a backup/restore migration. We recently dealt with this when upgrading from 2008 Ent to 2012 Std (and rolling our own implementations of the one or two Enterprise features we really needed). –  db2 May 29 '13 at 14:38
1  
@db2 Yes. You are correct. My point was to highlight safe route - backup/restore vs detach/attach as in the former atleast you have good backups. There is a dmv that can see what features are enabled -- SELECT * FROM sys.dm_db_persisted_sku_features; –  Kin May 29 '13 at 14:45
    
I can confirm that the "this approach with scripts" method works well if you can take the outage. I've used this method several times and as long as the instance name and paths are installed the same as before you should be good. –  Jason Cumberland May 30 '13 at 17:31
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.