22 Februari 2012 14:34
I just realized that Backup and restore between different instances of MS SQL Server 2008 can fail:
This is what I got when doing backup/restore between 2008 (64bit) and 2008 (32bit) servers. Is there an overview that shows the SQL Server versions where I can exchange backups (black list or white list) between?
Are there backup options that I should use to get maximum compatability for restore?
Any hints are greately appreciated, cheers Dirk
22 Februari 2012 15:14
- Backups created with Microsoft SQL Server cannot be restored to an earlier version of SQL Server.
- The database being restored must be at least version 80 (SQL Server 2000) to restore to SQL Server 2008 R2. SQL Server 2000 or SQL Server 2005 databases that have a compatibility level less than 80 will be set to compatibility 80 when restored.
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.