>>>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.
>
>Naomi,
>
>Interesting that I have done it more than once. I have SQL 2008 for my development and a client with only 2005. I have restored my database on their system more than once. Maybe I should look back at my notes and provide the process for you try it yourself.
>Tim

I think you missed the "R2" in her message. Even so, I do not think it can be done 2008->2005 via backup/restore without going the script route (see link below). If you have successfully done this via backup and restore, PLEASE post the instructions because I could use them too! I would much prefer to backup/restore to accomplish it but have never been able to.

http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx