We have SQL Server 2008 R2, which is in production & cannot be shutdown at this stage. I have installed SQL Server 2016 Standard Edition. Can I copy the databases, users and logins, with .ldfs, .mdfs & .ndfs, or use backups to restore to the server running 2016 Standard Edition?

Note that my SQL Server 2008R2 Enterprise databases do not utilize any of the Enterprise features.


2 Answers 2


A quick Internet search for 'sql server restore enterprise to standard' indicates this is 'theoretically' possible if you're not using 'Enterprise' features. The only way you'll truly know is to actually attempt the restore of a backup from SQL Server 2008R2 Enterprise to SQL Server 2016 Standard.

Downgrade from SQL Server Enterprise Edition to Standard Edition

Migrating a database from Enterprise to Standard Edition

  • 1
    In terms of features, Standard and Enterprise editions are pretty much at parity since 2016sp1 - the differences that remain are licensing and artificial limits (how many cores and how much RAM each instance can use, and so on). This means that restoring from enterprise to standard is even safer than it once was. Dec 20, 2016 at 13:56
  • and you definitely want to do the backup and restore method rather than the detach and attach method. Mar 9, 2017 at 3:16

I know it seems silly but have you tried the Upgrade Advisor?

  • Thanks, but i have gone the old restore backup route, Installed MSSQL Server 2016 and Restored DB's one by one copied logins and Users and done....
    – user108063
    Mar 20, 2017 at 8:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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