Manual Method to Copy Database from one Server to Another
First of all, launch the SQL Server Management Studio from Object Explorer and connect to the Source Server.
Now, right-click on database, select an option Tasks, and then, choose Copy Database option.