General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
>>>>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.
We've owned that for years :-)
Fringe season3 is showing here on sky but I refuse to give my money to murdoch. May be illegal download time (again)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only