February 12, 2015 at 3:48 am
in database mirroring, how data transfer happen from Principal to Mirror server? is data transfering thru End points?
in Log shipping, data transfer through Jobs!
here any such kind of mechanism is there in mirroring? please clarify me
February 12, 2015 at 6:13 am
the transactions are transferred via the mirroring endpoints and a redo thread on the mirror applies the transactions.
What exactly is it you want to do?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2015 at 7:34 am
The goal of database mirroring is to keep two databases synchronized in near real-time for High Availability/Disaster Recover (HA/DR) purposes and the mechanism to achieve that is as Perry states.
It's true that a form of disaster prevention can be gained via Log Shipping because you can configure the lag between transaction log backups being taken on the Primary and being restored on the Secondary so if someone dropped a table on the Primary you'd have a chance of preventing that table being dropped on the Secondary, but the longer that lag period is, the less suitable Log Shipping is as a HA/DR solution.
What perceived benefit of Log Shipping are you hoping to realize through the use of Database Mirroring?
Regards
Lempster
April 5, 2016 at 1:28 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply