>>>Hi Charles,
>>>
>>>Just a note about moving database from SQL 2008 R2 back to 2005. I have done this with a backup copy but there is a compatibility setting of some sort that must be set on the database before you do the backup. Took me a bit to find it but have done it a few times.
>>>Tim
>>>
>>
>>You can not restore a backup of SQL 2008 R2 on SQL 2005 (or SQL 2008). You need to use publishing wizard to script the data. Here you do need to check older version. I think it's one of the options in the Wizard.
>
>Can't you just change the database compatibility mode (assuming you haven't used any of the new stuff) then do the backup? Right-click on the database > Properties > Options > Compatibility level: SQL Server 2005 or does this not work?
No, it does not work for backup/restore. It partially prevents you from using new features while working in the newer version of SQL Server.
If it's not broken, fix it until it is.
My Blog