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

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

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

Postby jason_dev » Thu Sep 20, 2012 9:04 pm

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
jason_dev
 
Posts: 6
Joined: Mon Jul 02, 2012 10:17 pm

Postby petey » Fri Sep 21, 2012 1:37 am

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 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests