Post reply

how the database process and what will happen in backgroud if the On the same point of time differantial and log shiiping occur

  • April 16, 2014 at 9:38 am

    #306711

    how the database process and what will happen in background if the On the same point of time differential and log shipping occur

  • April 16, 2014 at 12:54 pm

    #1706559

    Differential and log backups can run at the same time, there's no problems doing so.

    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

  • April 16, 2014 at 10:58 pm

    #1706642

    if differential backup will occur on 12:05 AM and same logshipping on 12:05 Am,then who will get the priority.

    can we identify that condition from query..??

  • April 17, 2014 at 12:25 am

    #1706651

    What do you mean by 'priority'? They can run concurrently.

    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 4 posts - 1 through 3 (of 3 total)

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