Backup-Restore Version advice

ApocApoc Posts: 37
edited August 26, 2009 3:59AM in SQL Backup Previous Versions
Hi,

we do have a SQL Server 2005 running SQL Backup 5.4 and a SQL Server 2008 running SQL Backup 6.0.

Questions:
Can I backup a 2005 database using SQL Backup 5.4 and restore the backup set on the 2008 server using SQL Backup 6.0?

Can I backup a 2005 database on the 2008 SQL Server using SQL backup 6.0 and restore the backup set on the 2005 server using SQL backup 5.4?

Regards,
Thomas
Thomas Stensitzki
MCITP, MCTS, MCSA, MCSA: Messaging
http://www.icomcept.de
http://www.sf-tools.net
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    For SQL Server:
      - you can restore a SQL Server 2005 database on a SQL Server 2008 instance - you cannot restore a SQL Server 2008 database on a SQL Server 2005 instance
    For SQL Backup:
      - you can restore a backup created with any version of SQL Backup with SQL Backup 6 - you cannot restore backup files created with SQL Backup 6 using SQL Backup 5
    So it's yes to your first question, but no to your second question (due to the SQL Backup restriction).

    Thanks.
    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.