schema in sqlserver

Posted on 2014-08-28
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

    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 20

    Assisted Solution

    by:Tapan Pattanaik
    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 14

    Assisted Solution

    by:Vikas Garg

    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 44

    Accepted Solution

    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


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now