Post reply

Backup and restore in SQL 2008

  • January 16, 2009 at 1:15 pm

    #198856

    If I create a Database Backup from a SQL Server 2008 Instance, can I restore this backup on a SQL Server 2005 Instance?

    Thank You

  • January 16, 2009 at 1:57 pm

    #928510

    Themis Tokkaris (1/16/2009)

    If I create a Database Backup from a SQL Server 2008 Instance, can I restore this backup on a SQL Server 2005 Instance?

    No. It is never possible to downgrade a database, not by backup-restore, not by detach-attach. This is regardless of compatibility level (which just affects the parser and query execution engine)

    The only way to do this is to generate scripts of all the objects, export all the data and then recreate the database on the lower version.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

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