September 25, 2013 at 12:03 pm
Hi
I have some basic doubts between mirroring and log shipping .I know there is net but i didn`t proper result.In log shipping one have transactional backups occurring and then those backups files are shipped to secondary which are then restored.
how is this carried out in mirroring , i mean where are this log files and how are they shipped
September 25, 2013 at 12:25 pm
anoop.mig29 (9/25/2013)
how is this carried out in mirroring , i mean where are this log files and how are they shipped
Automatically. In mirroring the log records are sent across continually.
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
September 25, 2013 at 10:42 pm
GilaMonster (9/25/2013)
anoop.mig29 (9/25/2013)
how is this carried out in mirroring , i mean where are this log files and how are they shippedAutomatically. In mirroring the log records are sent across continually.
but where are this log files kept
I mean in logshipping there is folder where log files backups are stored but i donot see in any folder in which mirror log files are stored.
Second how this log are sent i mean using sql agent or through any other way
September 26, 2013 at 3:13 am
anoop.mig29 (9/25/2013)
but where are this log files kept
Where ever you choose to put the log backups that you take. Mirroring doesn't use log backups, so where they go is irrelevant. I imagine you'll put them with the rest of your backups
Second how this log are sent i mean using sql agent or through any other way
They're sent automatically across the mirroring end points that you set up when you configured mirroring.
May I suggest google and look for a good article on the basics of mirroring?
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
September 28, 2013 at 2:22 am
GilaMonster (9/26/2013)
anoop.mig29 (9/25/2013)
but where are this log files keptWhere ever you choose to put the log backups that you take. Mirroring doesn't use log backups, so where they go is irrelevant. I imagine you'll put them with the rest of your backups
Second how this log are sent i mean using sql agent or through any other way
They're sent automatically across the mirroring end points that you set up when you configured mirroring.
May I suggest google and look for a good article on the basics of mirroring?
hi i know google but can u suggest one
September 28, 2013 at 4:38 am
I don't have links to any offhand. I use google for that.
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply