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

Negative Spids - Recovery Expand / Collapse
Author
Message
Posted Tuesday, July 31, 2012 5:20 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 1,380, Visits: 2,705
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 #1337796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse