You will need to create aback up file for the database then again restore it in the other device. SQL Server Management studio can make your work easier.

Hi try this... https://technet.microsoft.com/en-us/library/ms187510(v=sql.110).aspx

If it is acceptable that a database could be off-line for few minutes (non production environments), you can also detach (from source server) and attach (on target server) the database which is lot quicker than back and restore. You will of course need to copy the .mdf and .ldf files.

Answers

a database in SQL and I want to copy to another machine

Uday Bhan Singh

820

how

Answers (3)

Next Recommended Forum

how to find out last updated row in sql ?

Hierarchical Data usign Self Join

Forum Statistics

Please welcome our newest member Abu Dhabi Visa.
3,083,139 users have contributed to 147,418 threads and 483,473
In the past 24 hours, we have 10 new threads, 21 new posts, and 130 new users.
In last week, the most popular thread is 'System.Data.SqlClient'.

Upcoming Events

View all

Deep Dive into Flutter, NoSQL, and Power Fx
Excel Automation with Power Automate : Automate Your Business Processes - Ep.3
Global Azure Bootcamp - Rasipuram