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

Strange issue - process in rollback not displaying rollback Expand / Collapse
Author
Message
Posted Sunday, June 23, 2013 12:04 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 2:06 PM
Points: 611, Visits: 516
I have a killed process that isn't showing a rollback. when I execute kill [spid] i get a timer and a % for rollback. What it does show is that it's "awaiting command" and FCB_Replica_Write.

I do have two pull replications on this server that i would gladly remove if it would speed this process up. one issue is that I do not have this replication setup in CM and the rollback is blocking the scripting processes to save the setup. Is anyone familiar with this? This is the first time I've run across this error. I do suspect a disk issue, but I cannot run a checkdb due to the rollback in progress.

Any help is appreciated. Currently the idea is to just wait it out and let the rollback complete (instead of restarting and having it complete during restore)


.
Post #1466540
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse