July 13, 2010 at 2:28 am
hello experts,
technically in log shipping transaction log backup from primary server is taken and copied to the secondry server and restored on secondry server. i wanna knw wat happens technically in mirrioring??
thank you
July 13, 2010 at 2:42 am
transaction log is transferred from principal to mirror
July 13, 2010 at 2:45 am
performance wise which is much better???
July 13, 2010 at 2:49 am
MIrroring you can have automatic failover
July 13, 2010 at 3:23 am
Log shipping is a simpler technology - you back logs up, and you restore them at a later time on the other server. The later time may be immediately (a delay of perhaps a minute or so), or potentially hours or days later.
Mirroring can be thought of as a real-time log shipping. It has two modes - "high safety" (synchronous) and "high performance" (asynchronous). In both modes, transaction log records are copied to the mirror. The difference between the two is that "high safety" will only commit the transaction on the principal once the mirror safely has the transaction committed. In other words, "high safety" has a dependency on the mirrored server, and its more real-time, whereas "high performance" has a slight delay (but is usually less than a few seconds off).
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply