SQL Server doesn??™t supply an actual
interactive monitoring tool. The monitoring server, which you can specify by selecting a
specific instance on the main log-shipping configuration dialog, simply runs periodic
jobs to collect history information and sends out alerts, as you can see in Figure 6-17.
Figure 6-17. Creating a log-shipping monitoring instance
CHAPTER 6 n MAINTAINING A WARM STANDBY SERVER VIA LOG SHIPPING 170
Notice that the job schedule is set to start automatically when SQL Agent starts.
This might seem odd until you see the stored procedure that is executed
(msdb.dbo.sp_add_log_shipping_monitoring_jobs). This stored procedure simply adds the
required jobs to gather backup history information from the primary and secondary
databases. Later, that data shows up on the Transaction Log Shipping Status report. You
can run this report by right-clicking on the SQL Server instance, selecting Reports, and
then selecting the Transaction Log Shipping Status report.
What are you really monitoring? The success and failure of backup and restore SQL
Agent jobs. Are there other ways to monitor this? Of course.
Pages:
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334