Post reply

Running Frequently Transaction logbackup during Integrity check DB

  • July 6, 2014 at 9:28 pm

    #296278

    Running Frequently Transaction logbackup during Integrinty check DB /optimization job will cause any issue /impact as duration will extend please explain

  • July 7, 2014 at 2:08 am

    #1727286

    No.

    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

  • July 7, 2014 at 4:43 am

    #1727309

    Because DBCC runs on a snapshot of the database, the two processes won't interfere with each other.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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