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. Wow, that was on quite a while ago over here. It didn't make much of a splash compared to many other HBO series.
Yes.
Its not here now they just thought It was good.
If you can get hold of them there are two UK series I'd recommend Being Human and Misfits. Both excellent.
Previous
Next
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