Red Gate forums :: View topic - Database "In Recovery"
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

Database "In Recovery"

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JimCarnicelli



Joined: 18 Jul 2011
Posts: 2
Location: United States

PostPosted: Mon Jul 18, 2011 2:11 pm    Post subject: Database "In Recovery" Reply with quote

In all my years of working with Sql Server and the SSMS I've never seen a database listed as "In Recovery". Since installing SQL Source Control a week or so ago, I've now seen it twice.

"In Recovery" appears to be a mode that SQL Server puts a database catalog into when it was incorrectly shut down due to, say, a sudden power loss. The ACID nature of Sql Server guarantees that transactions either wholly succeed or wholly fail. So if the server crashes during a transaction, it is necessary on starting it back up to either complete or roll back any transactions that were previously in operation. It's fairly amazing how durable (the D in ACID) this process is.

So far, I don't see any corruption of my small test database as a result of this, but I am concerned at the thought that SQL Source Control could somehow trigger this. Has anyone else experienced this before?

Some particulars of my situation. I am running a MacBook Pro with Parallels, a virtual machine program hosting a Windows 7 Home Premium VM, on which I'm running SQL Server Express 2008 and SQL Server Management Studio 2008. This most recent time I did a full, ordinary shut-down of my VM Friday and Monday morning did a regular start-up, manually starting the SQL Server service manually and launching into SSMS moments later. There is no other program connecting to this instance of SQL Server currently. And there is only one (user) catalog installed on it for now.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Wed Jul 20, 2011 4:52 pm    Post subject: Reply with quote

Thanks for your post.

I've not heard of this problem occurring before in relation to SQL Source Control, and I'm not really sure how it would occur. We perform queries against the database to poll for changes (these are only reading information), and of course if you "Get Latest" changes from your source control system down into your database, this would write data.

It's worth you checking through your SQL Server ErrorLog for possible causes. If you're not performing any restore operations on the database then it sounds like it's perhaps not being shut down cleanly. Given the VM nature of the environment you have, this could occur if your VM goes to sleep and the host machine is then turned off before any VM snapshotting takes place? Just a guess.
Back to top
View user's profile Send private message
JimCarnicelli



Joined: 18 Jul 2011
Posts: 2
Location: United States

PostPosted: Wed Jul 20, 2011 4:57 pm    Post subject: Reply with quote

Some good thoughts. To be sure, though, I never saw this prior to installing SQL Source Control a week or so ago, even though I've been running my VM and Sql Server on it for quite some time.

I did recently do a rebuild of the VM, which means there are some additional variables to consider. Thanks for reviewing this.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Wed Jul 20, 2011 5:00 pm    Post subject: Reply with quote

No problem - if you get anything in the error log that points to Source Control causing this do let us know, but it's certainly not something we've heard of before. I think it's more likely that any extra processing it's now doing due to SSC being installed has perhaps highlighted another problem.

If you want to get in touch with us directly with further queries, please mail support@red-gate.com with F0050277 in the subject line
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group