SQL-Server: Error – Exclusive access could not be obtained because the database is in use October 25, 2022 by Tarik Set the path to restore the file. Click “Options” on the left hand side. Uncheck “Take tail-log backup before restoring” Tick the check box – “Close existing connections to destination database”. Click OK.