Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
danesh1
Starting Member
7 Posts |
 Posted - 2010-04-09 : 12:01:04
|
| Hello,I am using MS SQL Server 2008 running on Windows Server 2008 R2.I'm new in the MS SQL server world. But I need to copy one SQL Server database on machineA to machineB. The SQL server database is called MUCC on machineA. I have created an empty SQL Server database called MUCC on machineB.How do I copy over the MUCC database from MachineA to MachineB?Can anyone give me some examples of commands,etc,etc.Any help would be appreciate.Thank you so much!Sincerely,DanD.Qureshi |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-04-09 : 13:00:18
|
| You can use BackUp and Restore approach..If the server is not production then you can take the mdf and ldf file and copy the same in new server. (you may need to detach the database for a while for this approach)Regards,Bohra.I am here to learn from Masters and help new bees in learning. |
 |
|
|
danesh1
Starting Member
7 Posts |
Posted - 2010-04-09 : 13:08:24
|
| Please note I want to copy over the MUCC database to the Production machineB from test machineA.D.Qureshi |
|
|
|
|
|
|
To copy SQL Server DB from machineA to machineB