Post reply

SQL SERVER 2008 R2 transaction log shipping

  • February 5, 2014 at 10:21 am

    #1686277

    sanku.raghuram (2/5/2014)

    Sorry for mis confusion and comming to Shawpoint-- you mean replication and transaction logshipping will work together.

    In that which order we go fist ,,

    Yes they do and either order. They don't conflict with each other so it doesn't really matter.

    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

  • February 6, 2014 at 7:28 am

    #1686593

    Hi Shaw,

    Thanks sharing the details. I have one more question. I see that I have set the restore job to happen 2 min dalay.

    so when my job runs first it skipped the transaction logs but when I again ran it it restored it.

    do i need to wait for 2 min to be over. do you think that the reason for the log getting skipped.

    Please respond as the earliest.

    Thanks

  • February 6, 2014 at 7:47 am

    #1686606

    if you set up a delay then the log will not restore until that delay time has passed

    ---------------------------------------------------------------------

  • February 6, 2014 at 7:52 am

    #1686610

    sanku.raghuram (2/6/2014)

    Thanks sharing the details. I have one more question. I see that I have set the restore job to happen 2 min dalay.

    so when my job runs first it skipped the transaction logs but when I again ran it it restored it.

    do i need to wait for 2 min to be over. do you think that the reason for the log getting skipped.

    No idea to be honest. As long as it does restore and allows you to stat within your SLAs I wouldn't worry too much.

    Please respond as the earliest.

    Am I your employee now?

    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

  • February 6, 2014 at 8:09 am

    #1686625

    What do u mean I am your employee?

    sry for the confusion, Not sure seems like you mis undetstood, I am requesting to get the information if possibble sooner.

  • February 6, 2014 at 8:16 am

    #1686628

    two minutes have passed, has the log restored now?

    ---------------------------------------------------------------------

  • February 7, 2014 at 3:08 am

    #1686945

    Read this[/url], it may help in the future

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 24, 2014 at 12:18 pm

    #1691686

    George is right. Follow his steps.

    --

    SQLBuddy

Viewing 8 posts - 16 through 22 (of 22 total)

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