I assume you would be able to take a backup taken from SQL Server 2005 and restore that backup onto SQL Server 2008. However, is it possible with Redgate Backup to restore in the other direction - i.e. take a backup from SQL Server 2008 and restore it to a 2005 database? I know there are new features and structures in 2008 that are not backwards compatible, but if you had a database running on 2008 at compatibility level 90 for 2005 and were using none of the 2008 specific features would the backup be backwards compatible?
I ask in the context of a planned rolling upgrade to 2008 (form 2005) and we ideally would need to be sure we could restore backups from the 2008 instances to the 2005 servers if we had to.
Thanks for any help,