How to view the status of servers configured for log shipping (Enterprise Manager)
SQL Server 2000
To view the status of servers configured for log shipping
- Expand a server group, and then expand the monitor server.
- Expand Management, and then click Log Shipping Monitor.
- In the details pane, right-click the log shipping pair to monitor, and then click Properties.
- Click the Status tab, and then view information about the status of both the source and destination servers.
Information about the last backup file, the last file copied, and the last file restored is also displayed.