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

Yes, check your notes for the exact process you performed. I know for a fact that you can not restore backup of a higher version in a lower version.