Post reply

Transaction log shipping and transaction log replication

  • March 26, 2010 at 12:15 am

    #217074

    Waht is the diffrence between the Transaction log shipping and transaction log replication. how they transfer the the data from one server to another server?

  • March 26, 2010 at 2:00 am

    #1140174

    Transaction log replication? Do you mean 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

  • March 27, 2010 at 6:15 am

    #1140920

    Yeah It is Transactional replication:-)

  • March 27, 2010 at 8:33 am

    #1140936

    With replication the log reader reads through the tran log looking for transactions that are marked 'for replication'. When it finds those, it sends them to the distributor where they are temporarily stored before being sent to the subscriber.

    With log shipping, transaction log backup files (same as created via BACKUP LOG) are sent to the standby server and restored.

    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

  • March 27, 2010 at 1:02 pm

    #1140962

    same again.

    Log shipping happens at whole database level.. no option to select objects.

    Transaction replication facilitates you to select objects and filter the data.

Viewing 5 posts - 1 through 4 (of 4 total)

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