Post reply

Log Shipping destination stuck on "restoring..."

  • September 12, 2014 at 8:35 am

    #1745109

    Hey GilaMonster, I have set up Transactional Replication and I am totally loving it! It works like a champ. Thanks for the excellent suggestion. 😎

  • September 12, 2014 at 9:40 am

    #1745132

    cafescott (9/12/2014)

    Hey GilaMonster, I have set up Transactional Replication and I am totally loving it! It works like a champ. Thanks for the excellent suggestion. 😎

    I don't think Gail suggested using Transactional Replication to meet your requirements; quite the opposite in fact!

  • September 12, 2014 at 11:53 am

    #1745166

    Lempster (9/12/2014)

    cafescott (9/12/2014)

    Hey GilaMonster, I have set up Transactional Replication and I am totally loving it! It works like a champ. Thanks for the excellent suggestion. 😎

    I don't think Gail suggested using Transactional Replication to meet your requirements; quite the opposite in fact!

    Err... Please quote where I recommended not to use it, because I can't recall doing so.

    Does anyone have a suggestion about copying a production database during business hours? The solution has to be within SSMS. (In other words, no Baremetal backup.) Thanks,

    Transactional replication?

    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

  • September 15, 2014 at 1:28 am

    #1745377

    GilaMonster (9/11/2014)

    cafescott (9/11/2014)

    Based on your earlier comment I'm going to research Transactional Replication as it seems the best way to copy a production DB two or three times a day during work hours.

    That's not what transactional replication does. Replication is *continuous*

  • September 15, 2014 at 2:31 am

    #1745389

    Lempster (9/15/2014)

    GilaMonster (9/11/2014)

    cafescott (9/11/2014)

    Based on your earlier comment I'm going to research Transactional Replication as it seems the best way to copy a production DB two or three times a day during work hours.

    That's not what transactional replication does. Replication is *continuous*

    Again, where am I *recommending* that he not use the technology which I suggested he use?

    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 5 posts - 16 through 19 (of 19 total)

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