February 19, 2014 at 3:16 am
Hi,
In Log-Shipping the primary server database and secondary server database
both are in synch via transaction log file i.e. .trn backup.
But in mirroring how the transactions or newly added objects are transferred from principal server to mirrored server ?
Thanks in advance,
Nikhil P Desai
February 19, 2014 at 3:37 am
Pretty much the same way. Check out this link:
http://technet.microsoft.com/en-us/library/ms189852(v=sql.105).aspx
Regards
Lempster
February 20, 2014 at 3:32 am
Lempster (2/19/2014)
Pretty much the same way. Check out this link:http://technet.microsoft.com/en-us/library/ms189852(v=sql.105).aspx
Regards
Lempster
The synch method between LS and mirroring are completely different. LS involves sending t-log backups across the network to the secondary server where they are then restored.
Mirroring send log records in real time across the network, it does not use t-log backups
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2014 at 5:07 am
By 'pretty much' I meant because mirroring involves the transaction log, but you are right Perry, I should have been more specific. The link that I provided should give the OP much more information than is reasonable to include in a forum post.
In retrospect I should have just posted the link and said 'read this'! :unsure:
Regards
Lempster
February 20, 2014 at 5:15 am
Lempster (2/20/2014)
By 'pretty much' I meant because mirroring involves the transaction log
everything involves the t-log, it's an integral part of the database structure
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2014 at 11:42 am
Yeah, they are correct. In Mirroring,there's a difference in how the transactions are committed in Synchronous and Asynchronous mirroring modes. Just check that.
--
SQLBuddy
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply