title: SQL server restore failure for Umbraco Database (exclusive access can't be obtained) - a process keeps getting connected
body: <p>I've set my DB into restricted user mode.  I'm trying to restore it from a backup, but get the following error:</p>
  
  <p>Exclusive access could not be obtained because the database is in use. </p>
  
  <p>Get the same error in single user mode</p>
  
  <p>There's a process connected, however every time I kill it off, a process with a different SPID connects.  Is this expected or is this the issue (I'm no DBA!)</p>
  
  <p>I've tried:</p>
  
  <ul>
  <li>Googling for a solution :)</li>
  <li>detaching the DB (fails with a similar error about a lock on the DB)</li>
  </ul>
  
  <p>I'm nervous to drop the DB (it's only UAT, but still...)</p>
  
  <p>What next?</p>