InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 00:27:35 GMT20http://www.sqlservercentral.com/Forums/Topic1267237-1239-1.aspxThanks Luke, so now I finally understand what the monitoring server is for. We currently use SCOM to monitor the LSAlert jobs and create a ticket if the LSAlert job fails. If I setup a monitoring server, what additional information can I monitor? I looked at ms190224 and it does not appears that there is a lot of additional information.Fri, 16 Mar 2012 08:11:57 GMTron.gordonhttp://www.sqlservercentral.com/Forums/Topic1267237-1239-1.aspxRon, there are several benefits in using a remote log shipping monitor. They include1. Centralized monitoring and alerting solution. If you have several instances participating in log shipping throughout your enterprise this would allow you to view the overall health of those instances (provided you setup a remote log shipping monitor :-D).2. The transaction log shipping status report on the monitor displays the status of backup, copy and restores for the instances using the monitor (instead of having to look at each primary and secondary instances). Those values listed in red have exceeded their set thresholds and action is needed.3. If either the primary or secondary instance goes offline, or SQL Server Agent is stopped, you'll still receive alerts from the remote monitor. For example, if the primary went offline you'd no longer receive alerts when your backup threshold was exceeded.For more information take a look at the link below. Thanks for reading! http://msdn.microsoft.com/en-us/library/ms190224.aspxFri, 16 Mar 2012 07:31:44 GMTLuke Chttp://www.sqlservercentral.com/Forums/Topic1267237-1239-1.aspxGreat article!!Thanks for sharing it in a detailed step by step way..Thu, 15 Mar 2012 23:13:20 GMTnaresh.mosamhttp://www.sqlservercentral.com/Forums/Topic1267237-1239-1.aspxok, now that you have a log shipping monitoring server, what can you do with it?Thu, 15 Mar 2012 14:27:20 GMTron.gordonhttp://www.sqlservercentral.com/Forums/Topic1267237-1239-1.aspxI created a new thread in the SQL 2008 HA section where I have to look at both primary and secondary/monitor servers to get the information I require. Check [url=http://www.sqlservercentral.com/Forums/Topic1263641-1549-1.aspx]here[/url].Good article.[b]qh[i][/i][/b]Thu, 15 Mar 2012 09:17:47 GMTquackhandle1975http://www.sqlservercentral.com/Forums/Topic1267237-1239-1.aspxGood one.Thu, 15 Mar 2012 02:52:42 GMTyuphttp://www.sqlservercentral.com/Forums/Topic1267237-1239-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Log+Shipping/77295/">Adding a log shipping monitor</A>[/B]Wed, 14 Mar 2012 22:23:03 GMTLuke C