Adding a log shipping monitor

Question

Post reply

Adding a log shipping monitor

Luke C

Right there with Babe

Points: 790
More actions
March 14, 2012 at 10:23 pm

#258671

Comments posted to this topic are about the item Adding a log shipping monitor
Luke C
MCSE: Data Platform, MCP, MCTS, MCITP - Database Administrator & Database Developer

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

yup SSCarpal Tunnel Points: 4490 More actions · Answer 1

yup

SSCarpal Tunnel

Points: 4490

March 15, 2012 at 2:52 am

#1459685

Good one.

quackhandle1975 SSChampion Points: 11055 More actions · Answer 2

I 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 here.

Good article.

qh

[font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

Blade69 SSC Enthusiast Points: 140 More actions · Answer 3

ok, now that you have a log shipping monitoring server, what can you do with it?

naresh.mosam SSC Enthusiast Points: 115 More actions · Answer 4

Great article!!Thanks for sharing it in a detailed step by step way..

Luke C Right there with Babe Points: 790 More actions · Answer 5

Ron, there are several benefits in using a remote log shipping monitor. They include

1. 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.aspx

Luke C
MCSE: Data Platform, MCP, MCTS, MCITP - Database Administrator & Database Developer

Blade69 SSC Enthusiast Points: 140 More actions · Answer 6

Thanks 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.

achantamahesh 69149 Grasshopper Points: 17 More actions · Answer 7

Hi,

I have only primary server and secondary server in my environment and my management want to add the secondary server as monitoring server.

Can you please guide me how to add the secondary server as monitor server to an existing log shipping setup.

Thanks in advance.

RobehL SSC Enthusiast Points: 121 More actions · Answer 8

Luke,

According to the stored procedure for [sp_processlogshippingmonitorprimary] , the @mode usage for :

[sys].[sp_processlogshippingmonitorprimary]
(
@mode tinyint -- 1 = add, 2 = delete, 3 = update

Is this not right? I'm using your instruction to update an old monitor server to a new one.