677
Chapter 26: Log Shipping
26
■ (^) On the monitor server:
- Expand SQL Server Agent and review the Alert job, log shipping primary server
alert, and log shipping secondary server alert.
Monitoring Log Shipping
To monitor log shipping from SQL Server Management Studio, Microsoft provides a
Transaction Log Shipping Status report. This report can be run on any SQL Server par-
ticipating in the log shipping confi guration. To run the Transaction Log Shipping Status
report, execute the following steps:- Connect to the primary, secondary, or monitor server using Object Explorer in SQL
Server Management Studio. - Right click the SQL Server instance; click Reports.
- Click Standard Reports.
- Click Transaction Log Shipping Status.
For a complete picture of the Log Shipping confi guration, run this report on the monitor
server, as shown in Figure 26-10.FIGURE 26-10
Executing the Transaction Log Shipping Status report on monitor server.c26.indd 677c26.indd 677 7/31/2012 9:49:20 AM7/31/2012 9:49:20 AM
http://www.it-ebooks.info