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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 To copy SQL Server DB from machineA to machineB

Author  Topic 

danesh1
Starting Member

7 Posts

Posted - 2010-04-09 : 11:56:52
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,
Dan


D.Qureshi

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-04-09 : 11:58:26
easiest way is to backup the database on ServerA and restore it to ServerB
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-04-09 : 13:57:14
Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=142742
Go to Top of Page
   

- Advertisement -