Is it safe to kill DBCC Shrinkfile? The process has been running for 30 minutes on an 11GB database. I have no idea how much more time it will take to shrink the database and would like to kill it, assuming that would not cause a 30 minute rollback.
I presume this is still not running
I'd say it'd be a safe bet that killing a process thats shuffling data around in the database is not a good thing to do
DBCC Shrinkfile is transaction safe. You can cancel it at any time.
We would have to cancel this process when the shrinkfile failed to finish during the "quiet" time.
Thanks Rick. Fortunately it completed just before I killed the process.
We walk in the dark places no others will enterWe stand on the bridge and no one may pass