[Last Call] Learn how to a build a cloud-first strategyRegister Now


schema in sqlserver

Posted on 2014-08-28
Medium Priority
Last Modified: 2014-10-17
can i restore database from sqlserver 2008 R2 Enterprise edition to standard edition
Question by:praveen1981
LVL 23

Expert Comment

ID: 40289831
For as far as i'm aware yes. The main difference between Enterprise and standard is that you are able to assign more memory and CPU to the enterprise edition and you can also add multiple instances. Standard can only have 1 instance.
LVL 22

Assisted Solution

by:Tapan Pattanaik
Tapan Pattanaik earned 501 total points
ID: 40289839
Hi praveen1981,

If I have a database that has enterprise features (data compression,transparent data encryption,partitioning,change data capture) and try to restore it to an SQL Server 2008 Standard Edition instance It will fail.
LVL 15

Assisted Solution

by:Vikas Garg
Vikas Garg earned 498 total points
ID: 40289864

All the Microsoft products comes with backward compatibility so restoring lower version to higher will never give you error but from higher to lower may cause since those features are not in the lower one to cope up.

So if the enterprise database is there which does not support any feature compare to standard then it will not restore on Standard.
 Otherwise it will ....
LVL 53

Accepted Solution

Vitor Montalvão earned 501 total points
ID: 40290019
Well, this is one of that questions that the answer is depends.
Like TAPAN wrote, if your database uses features that are only available in Enterprise Edition, then the answer it's no. Otherwise you won't have problems restoring it to a Standard Edition.

Author Closing Comment

ID: 40386457

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question