I need a copy of a live database called
Carers on the same server for testing purposes. The test database name will be
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!