Results 1 to 2 of 2

Thread: dump locking

  1. #1
    Join Date
    Dec 2001
    Posts
    16

    Exclamation Unanswered: dump locking

    Hi,

    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,

    Siva

  2. #2
    Join Date
    Sep 2002
    Posts
    8

    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
  •