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

Thanks Charles

went for the backup restore option.

I did try the export import wizard first but it was extremely slow.

BTW son and I both gave up on justified as we both realised independently that we didn't care about any of the characters.

Now someone is trying to persuade me to watch Carnivale