SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Adding a log shipping monitor


Adding a log shipping monitor

Author
Message
Luke C
Luke C
Old Hand
Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)

Group: General Forum Members
Points: 398 Visits: 1223
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
yup
yup
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2570 Visits: 1029
Good one.
quackhandle1975
quackhandle1975
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5871 Visits: 1244
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

Who looks outside, dreams; who looks inside, awakes. – Carl Jung.
ron.gordon
ron.gordon
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 137
ok, now that you have a log shipping monitoring server, what can you do with it?
naresh.mosam
naresh.mosam
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
Points: 97 Visits: 70
Great article!!Thanks for sharing it in a detailed step by step way..
Luke C
Luke C
Old Hand
Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)

Group: General Forum Members
Points: 398 Visits: 1223
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
ron.gordon
ron.gordon
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 137
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
achantamahesh 69149
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 122
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
RobehL
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 7
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search