Restore a database with a different name on the same server I need a copy of a live database called Carers on the same server for testing purposes. The test database name will be Carers_Test.

I took a backup of Carers using SSMS. And tried to restore it using the GUI. When I followed the steps, the only thing I changed was the name of the database. 

But the restore fails with the error: 


  Exclusive access could not be obtained because the database is in use.


I do not want to do anything with the current live database, why is that matter that the database is in use? 
I have tried to restore the same backup on my local host and it restored successfully. When I try to restore it on the same server with the live database then I get this error. 

Please someone help me...I'm going crazy!
It's really simple to solve. You are trying to override the original files you need to you use the move option like this:
restore database &lt;Your-Database&gt; from disk ='&lt;backup-file-path&gt;' 
with move 'mdf_file_name' to '&lt;new-path&gt;',
move 'log_file_name' to '&lt;new-path&gt;'

By the way to discover the file name from backup use this command:
restore filelistonly from disk ='&lt;backup-file-path&gt;'