Results 1 to 2 of 2

Thread: dump locking

  1. #1
    Join Date
    Dec 2001

    Exclamation Unanswered: dump locking


    Yesterday I am taking my database dump. I find that dump database spid locked some other "insert" command spid.

    Is any one knows why it was happed like that? Are any steps to avoid?

    Thanks & Regards,


  2. #2
    Join Date
    Sep 2002

    Re: dump locking

    Its normal !
    may be Your dump process was reading the pages with share lock
    while the other spid tryed to get a exclusive lock. usualy it s only happen for short duration you can't even notice.
    Best way to avoid is do the dump process when no one using the databases. at least there is n open trancation.
    and its a good idea to run a checkpoint before taking a dump.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts