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?
· Share on Twitter

Comments

  • Options
    priyasinhapriyasinha Posts: 548 Silver 1
    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
    · Share on Twitter
  • Options
    kermikermi Posts: 47
    I thought that would be the issue.. Thanks for your response
    · Share on Twitter
Sign In or Register to comment.