>>>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 has far fewer likeable characters than Justified <s> but I loved it. Very surreal so if that kind of stuff puts you off, you will find it pretty murky.
Why not just get the boxed set of Buffy the Vampire Slayer and revel in the genius of Joss Whedon.
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.
