title: Why does SQL Server say "Starting Up Database" in the event log, twice per second?
body: <p>I have a SQL Server [2012 Express with Advanced Services] database, with not much in it. I'm developing an application using EF Code First, and since my model is still in a state of flux, the database is getting dropped and re-created several times per day.</p>
  
  <p>This morning, my application failed to connect to the database the first time I ran it. On investigation, it seems that the database is in "Recovery Pending" mode. </p>
  
  <p>Looking in the event log, I can see that SQL Server has logged:</p>
  
  <blockquote>
    <p>Starting up database (my database)</p>
  </blockquote>
  
  <p>...roughly twice per second all night long. (The event log filled up, so I can't see beyond yesterday evening).</p>
  
  <p>Those "information" log entries stop at about 6am this morning, and are immediately followed by an "error" log entry saying:</p>
  
  <blockquote>
    <p>There is insufficient memory in resource pool 'internal' to run this query</p>
  </blockquote>
  
  <p>What the heck happened to my database?</p>
  
  <p>Note: it's just possible that I left my web application running in "debug" mode overnight - although without anyone "driving" it I can't imagine that there would be much database traffic, if any.</p>
  
  <p>It's also worth mentioning that I have a full-text catalog in the database (though as I say, there's hardly any actual content in the DB at present).</p>
  
  <p>I have to say, this is worrying - I would <em>not</em> be happy if this were to happen to my production database!</p>