How to copy a database from server to server or to another server?

1. Connect to SQL Server
2. Select the database
3. Right Click on the Database and select TASK
4. From task select COPY DATABASE
5. Then an COPY wizard will pop up.
6. Select the SOURCE SERVER and click next


7. Select the DESTINATION SERVER and click next
8. Click next and check the AUTHENTICATION
9. Click Next and then Finish.
10. Hence you database is copied to another database

Another way to copy within a server

1. Just Right Click on the database and go to TASK
2. Click on RESTORE/BACKUP database
3. A wizzard will pop up
4. Write the new name and click next next till finish.
5. It will copy the database in the same server.