Sunday, June 23, 2013

[MS SQL Server] Strange issue - process in rollback not displaying rollback

[MS SQL Server] Strange issue - process in rollback not displaying rollback

Strange issue - process in rollback not displaying rollback

Posted: 23 Jun 2013 05:04 AM PDT

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)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog