Killed DbccFilesCompact found running for days There were 2 running, actually, the first one I killed went away quickly. The second is in suspended status, from sys.dm_exec_requests the percent_complete doesn't change (88.87) and the estimated_completion_time keeps going up. What can I do? There is no room left on the one mdf file drive, is that the problem? This is why my coworker started the shrink (he's on vacation now, long story why they started doing the shrinks, databases is being moved to Hadoop, and I'm new (3rd week)). Please advise.. thanks!
I just killed it today and it went away immediately... hope this helps someone else. Thanks!