Logshipping restore job process is blocked by itself

  • We are configuring log shipping..here restore job process is blocked by itself...any solution?

    Thanks in advance...

  • Are you are referring to several lines showing up when you run sp_who2 with the same spid and sometimes the spid is displaying as blocking itself?

    If that is the situation, ignore it.

    These are usually (and during a restore always) page latch request blocks, not resource lock blocks.

    There is a long explanation about what these actually represent, but basically when a parallel process runs, multiple threads for the same process can request a latch to the same page. When this happens, SQL reports it as a process blocking itself.

    This is normal.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply