How to copy sql server database from one to another server without any backups

Question

I have two machines, A and B. In my machine A, I have SQL server with some database. I need to copy the database from Machine A to B without taking any backups. How do I do that?

Answer 1

You can use the Copy Database functionality in SQL Server Management Studio.

Right-click the database, select "Tasks", "Copy database". If you can take the database offline, you can also choose to detach it, copy the files to the new server, and then reattach the database after.

See also the Microsoft Documentation: http://technet.microsoft.com/en-us/library/ms188664.aspx