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
>>Hi
>>
>>
>>I've installed SQL2005 on my local machine and I want to take a copy of a database from the live server and install it on my local SQL server.
>>
>>Whats the best way of doing this.
>>
>>Thanks
>>
>>
>>Nick Mason
>
>Two options come to mind : Detach on live server, copy mdf and ldf to your local server and attach.
>
>Proabably easier : backup on live server, create database of same name on local server and then "restore" from backup from live server ( with overwrite etc )
>
>And remember if you put a 2005 database on a 2008 R2 server you can't downgrade it to 2005 if you need to go the other way.
Timothy Bryan