How to copy and rename an SQL Server database on the same server

Install Microsoft SQL Management Studio, you can download it for free from Microsoft website:

• Version 2008
  Microsoft SQL Management Studio 2008 is part of SQL Server 2008 Express with Advanced Services
  
  
• Version 2012
  Click download button and check ENU\x64\SQLManagementStudio_x64_ENU.exe
  
  
• Version 2014
  Click download button and check MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe


• Version 2016
  With the SQL Server 2016 RC0 release Microsoft split out the installation of SQL Server Management Studio from the main installation of SQL Server. Download SQL Server Management Studio (SSMS)

Open Microsoft SQL Management Studio

Backup original database to file (db --> Task --> Backup)

Don't create an empty database and restore the .bak file on to it, but use 'Restore Database' option accessible by right clicking the "Databases" branch of the SQL Server Management Studio and provide the database name while providing the source to restore.