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

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.

Nairisha Shrestha10y ago

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.