Skip to Content
0
Former Member
Jan 08, 2014 at 11:00 PM

database dump, update stats, reorg, dbcc blocks

172 Views

if a dump database or dump tran is running on a database, will it block other processes from executing on the db?

likewise with update stats, reorg, dbcc - in execution will they block other processes?

even within themselves - will a dump block a reorg or dbcc?

I have seen instances of this happening now and again, but would like to know more theory/reasons on this issue.

appreciate the feedback.