ananda.murugesan (12/14/2011)
Dev (12/14/2011)
You can take Log Backups on Primary Server.ok, If i have taken log backup every 30 min at principal server then what is frequency for Tlog apply at mirror server?
You're thinking of log shipping.
In database mirroring the log records are copied across by the mirroring functionality either before the transaction commits (synchronous) or shortly after (asynchronous). You have to take log backups to keep the log from growing and to ensure you can restore to an earlier point if necessary. The log backups aren't copied across and applied, that's log shipping.
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