Home Forums SQL Server 2005 Administering T- log backup is creating blocking in prod server RE: T- log backup is creating blocking in prod server

  • How have you identified that the log backup is the blocker? What is the lock type that it is holding? What is trying to get that lock?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass