How can i backup a database SQL Server 10.50.1600 to SQL Server 10.0.4000?

Posted on 2011-04-27
Last Modified: 2012-05-11
I need to copy the database that is in production to my local PC. When I try to do this, I get the error --the database was backup with version  0.50.1600, you need SQL Server 10.0.4000?
Question by:iscivanomar
    LVL 29

    Accepted Solution

    Unfortunately it is not possible to restore a SQL Server 2008 R2 backup to SQL Server 2008, which is what you are trying to do.
    LVL 6

    Assisted Solution

    I would suggest using SQL Delta to do the copy it is fast and easy and works with multiple versions for example MS SQL 2000 to MS SQL 2008 etc...
    LVL 21

    Assisted Solution

    by:Alpesh Patel
    Its good to create script of all objects and execute on destination.
    Import /Export data to destination.


    Author Closing Comment

    Thank you for the information. Fortunately, I got R2 now.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    779 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

    21 Experts available now in Live!

    Get 1:1 Help Now