Take a backup from SQL 2012 and restore it on SQL 2008

jason_devjason_dev Posts: 9
edited September 20, 2012 8:37PM in SQL Backup Previous Versions
Is it possible to use SQL Backup 7 to backup a SQL Server 2012 database and use SQL Backup 7 to restore the .sqb on a SQL 2008 server?

Jason
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    No it isn't possible. Under all that compression and encryption, the backup data is still stored in SQL Server's native backup format, and SQL Server 2008 cannot restore a backup created using a SQL Server 2012 instance.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.