Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Deferred Transactions - Database Recovery Expand / Collapse
Posted Thursday, July 26, 2012 12:03 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, June 26, 2015 8:07 AM
Points: 1,391, Visits: 2,767
Hi All

I'm confused about the the topic of Deferred transactions (-spids) and database recovery

I read and tested the steps in this article by Paul Randal:

I was able to re-create the situation

My question is that why does the Database come up as suspect?

Because the Database can't roll back/forward the transaction(s) because of the missing files, shouldn't the database go into a Recovery Pending state?


Post #1335573
Posted Tuesday, August 7, 2012 12:06 PM



Group: General Forum Members
Last Login: 2 days ago @ 1:39 PM
Points: 1,620, Visits: 1,571
Recovery pending means that it waiting an attempt to recover a file, not the it tried to recovery the file and failed.

My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1341458
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse