SQL Server Performance Forum – Threads Archive

sql server 2000 Log Shipping

we are using sql server 2000 Log Shipping .Pl help me , tell me about how
monitor Log Shipping and what are diffrent counters (performance and
other )
Ritesh Gupta
Software Engineer
Cybage Software Pvt. Ltd. (a CMM Level 3 company)
Phone(O) : 91-20-4041700, 91-20-4044700 Ext : 254
Cell : 91-9850412816
Fax : 91-20-4041701, 4041702
mailto: [email protected]
www.cybage.com

You could set up monitoring/reporting on the sql jobs that perform the logshipping, the same way as you would do on any other sql job running on the server. Not sure if any counters exist, haven’t looked into that.

Go thru this<a target="_blank" href=http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx>http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx</a> Technet document for reference about monitoring log shipping. As referred there are no special counters, apart from capturing the usual PERFMON counters get ‘SQL Server<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />atabases – Log growths ‘ for information on the log growth. HTH <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

]]>