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

Question

how

Nairisha Shrestha · Answer

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.

Vasanth Natarajan · Answer

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

Nitin Sontakke · Answer

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.