>>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?