>>>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
Do you mean 2008 R2 or 2008 ? That is where I think the difference is. You can't go back from 2008 R2 to 2008 IIRC
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.