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.'

  • Even if you place it in single user mode, if you're connected to that database or another connection is there, it might still be active when you try to run the backup. Generally I don't use single user mode, I use restricted user, but that assumes that most of our logins are not 'sa' and the ones that are I can kill or identify and alert individually.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning