Post reply

SQL Server 2008 Database backup

  • September 24, 2008 at 11:17 pm

    #193581

    Hi,

    Can we use backup created using SQL Server 2008 in SQL Server 2005. If yes tell me the process.

    Thanks & Regards,

    Srinivas M

  • September 25, 2008 at 10:07 am

    #877139

    Pretty certain it's NO, it is not backward compatible

    You can restore 2005 backup in 2008

    not restore 2008 backup to 2005

    However, now I do wonder, if you use 3rd party tool (such as LiteSpeed or RedGate SQL Backup)

    would it work...

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • September 25, 2008 at 10:56 am

    #877185

    No. It will not work.

    Not with any backup tool.

    The issue is not the backup app, but the fact that as part of the upgrade, the database physical structures are modified and upgraded.

    It's easy to allow SQL 2008 to understand a SQL 2005 database and upgrade it, but not reasonable to expect SQL 2005 to understand a new format that wasn't invented when SQL 2005 was written.

    And no, to answer the next question, compatibility mode will not save you. Compatibility mode ONLY impacts the way the parser deals with language elements which may have changed between releases. It has NO impact on the physical database structures. If a database is attached to a SQL 2008 instance, and has been brought online, it is in SQL 2008 format.

    Kevin Farlee
    SQL Server Storage Engine PM

  • September 25, 2008 at 11:10 am

    #877214

    Nope, as explained above.

  • September 25, 2008 at 11:11 am

    #877215

    Thanks Kevin

    That answered my imaginary question 🙂

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply