Monitoring Log Shipping & Mirroring

Question

Hi,

How we can monitor logshipping and mirroring?

Answer 1

Hi,

How we can monitor logshipping and mirroring?

for Logshipping use this linka nd below query

http://technet.microsoft.com/en-us/library/ms190224.aspx

--on primary
use msdb
go
select * from log_shipping_monitor_primary

--on secondary

use msdb
go
select * from log_shipping_monitor_secondary

For Mirroring see below link.You should monitor redo queue and Log queue which needs to be sent to mirror.

You can also use DB Mirroring monitor tool present .

http://technet.microsoft.com/en-us/library/ms190030.aspx#MonitoringStatus

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Answer 2

In addition

http://technet.microsoft.com/en-us/library/ms365809.aspx

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance