title: SQL Server 2005 Database 'In Recovery'
body: <p>I restored a 35Gb database on my dev machine yesterday and it was all going fine until this morning when my client app couldn't connect. So I opened SQL Management Studio to find the database 'In Recovery'.  </p>
  
  <p>I don't know a huge amount about this other than it is usually something to do with uncommitted transactions.  Now since i know there <strong>aren't any</strong> uncommitted transactions it must be something else.  So first off, I'd like to know under what conditions this can happen.  Secondly, while this is going on I can't work so if there are any ways of either stopping the recovery, speeding it up or at least finding roughly how long it's gonna be that would help.</p>