What are the challenges you face when working across database platforms? Take the survey
Options

sql2008 to sql2005

kermikermi Posts: 47
edited January 22, 2009 9:16AM in SQL Backup Previous Versions
Can you take a SQL2008 database backup and restore it to a SQL2005 server using SQL Backup 5?

Comments

  • Options
    Hi,

    No, backups are not backward compatible. So even though you can take a backup of SQL Server 2005 database and restore it to SQL Server 2008 but you cannot restore a SQL Server 2008 database backups to SQL Server 2005, 2000 etc etc.

    This is a SQL Server restriction and not a SQL Backup restriction.

    Thanks,
    Priya
    Priya Sinha
    Project Manager
    Red Gate Software
  • Options
    I thought that would be the issue.. Thanks for your response
Sign In or Register to comment.