Deferred Transactions - Database Recovery

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Data Corruption (SS2K8 / SS2K8 R2) » Deferred Transactions - Database Recovery

Deferred Transactions - Database Recovery

Rate Topic

Display Mode

Topic Options

Author

Message

SQLSACT

Posted Thursday, July 26, 2012 12:03 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:48 AM
Points: 1,200, Visits: 2,126

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: http://www.sqlskills.com/BLOGS/PAUL/post/Disaster-recovery-101-dealing-with-negative-SPIDS-(-2-and-3).aspx

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?

Thanks

Post #1335573

Robert Davis

Posted Tuesday, August 07, 2012 12:06 PM

SSCommitted

Group: General Forum Members
Last Login: Sunday, May 19, 2013 8:09 AM
Points: 1,558, Visits: 1,396

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
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring

Post #1341458

« Prev Topic | Next Topic »

Permissions