Post reply

T- log backup is creating blocking in prod server

  • October 31, 2013 at 6:27 am

    #279535

    hi all,

    guys need your help and suggestion

    T- log backup is creating blocking in prod server.what to do plz suggest.

  • October 31, 2013 at 7:08 am

    #1663035

    Ivan Mohapatra (10/31/2013)

    hi all,

    guys need your help and suggestion

    T- log backup is creating blocking in prod server.what to do plz suggest.

    http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-3030-backup-myths/

    Bearing in mind point 30-01 in that article, what makes you believe the backup is causing blocking?

    Steve Hall
    Linkedin
    Blog Site

  • October 31, 2013 at 7:35 am

    #1663044

    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

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

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