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

Carnivale. Wow, that was on quite a while ago over here. It didn't make much of a splash compared to many other HBO series.