Restore back up of sql 2008 serevr databse in sql 2005 serevr

Posted on 2009-02-19
Last Modified: 2012-05-06
I am using sql 2005 server and my client system they are using sql 2008 server.I got the back up of database from client which is related to sql i want restore it my system.but i am using sql 2005.I am getting error when i am trying to restore back up of sql 2008 serevr databse in sql 2005 serevr .Is there any way to do.
Question by:ravindra333
    LVL 57

    Accepted Solution

    No, you can't restore a backup from a higher version of SQL Server on a lower version of SQL Server.
    Backward Compatibility is there by default but forward Compatibility is not supported.

    If you are dead set on it, I think your best option is to selet the database in the Object Explorer in SQL 2008,
    right-click, select Tasks->Generate Scripts.In the options dialog enable everything, including Script Data.
    And make sure you select "Script for SQL 2005".

    Assisted Solution

    try taking a backup changing the compatibility mode and restore that in SQL 2005, just guesing not sure if this will work.


    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…

    755 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

    19 Experts available now in Live!

    Get 1:1 Help Now