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

865

how

Answers (3)

Forum Statistics

Please welcome our newest member Hanley Jenson.
3,097,558 users have contributed to 147,390 threads and 483,672
In the past 24 hours, we have 7 new threads, 16 new posts, and 86 new users.
In last week, the most popular thread is 'CRUD operations code in C#'.

Upcoming Events

View all

AI Agents Conference - 2025

Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training