How to find status of log shipping

Hi
  I have a few questions on log shipping
 1. how to find the status(in sync or out of sync) of log shipping in sql server 2000 as well as in sql server 2005?
 2. How to find which servers don't have log shipping monitor?

Thanks in Advance
2575069Asked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
< 1. how to find the status(in sync or out of sync) of log shipping in sql server 2000 as well as in sql server 2005?>
2005 ->ssms->right click your sql server -> report->Transaction log shipping status
2000 ->EM-> sql server-> log shipping monitor...- also there are 2 log ship alert jobs..
more:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx
--
2. 2000 - msdb -table- log_shipping_monitor
http://technet.microsoft.com/en-us/library/aa260601(SQL.80).aspx

2005- log_shipping_monitor_primary
http://msdn.microsoft.com/en-us/library/ms190355(SQL.90).aspx
0
 
2575069Author Commented:
Thanks Eugene...thats exactly what i needed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.