Home Forums SQL Server 2005 Administering Restore Database Failed: 'Exclusive access could not be obtained because the database is in use.' RE: Restore Database Failed: 'Exclusive access could not be obtained because the database is in use.'

  • In my case: I was logged in to SSMS as 'user_x'. Default database for 'user_x' was 'Test_DB'.

    I got same errormessage when I tried to restore in this session 'Test_DB'.

    When I logged out as 'user_x' and logged in SSMS as another user (that did not have default database 'Test_DB'), restore was successful.