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