This is how to make an exact copy of a SQL database on the same server or from another server:
- Open SQL Server Management Studio and right click on Databases in the Object Explorer. In the dialogue click New Database…
- Give the database a name and click OK
- Now, right click on the newly created database. Select Tasks -> Restore -> Database…
- In the popup window select the source database to restore from by selecting it in the From database: drop-down. Alternatively, if you have a backup you want to restore, you can select it in the From device: dialogue.
- Now, go to the Options tab. Under Restore the database file as: find Restore As and change the name of the file to what you would like. Do it for both entries in the list. (This is only needed if you already have the database on the server)
- Under restore options select Overwrite the existing database (WITH REPLACE)
- Once you are sure you have change the name click OK and the database will be restored in your new database