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

858

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 C'KiD .
3,095,579 users have contributed to 147,392 threads and 483,649
In the past 24 hours, we have 7 new threads, 23 new posts, and 115 new users.
In last week, the most popular thread is 'OOPS Concept'.

Upcoming Events

View all

The Cloud Show with Magnus Mårtensson ft. Mads Kempel Sørensen - Ep: 75
AI Agents Conference - 2025