Information générale
Forum:
Microsoft SQL Server
Versions des environnements
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)
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement