In SQL 2005 if I bring up the report "Transaction Log Shipping Status"
by right clicking on the db server and going to "Reports".
When I view the report I see two Trans shipping items that are in RED
cause these items don't exist anymore. They were deleted days ago.
And I just figured out how to get rid of them!
Delete them from this system table
msdb.dbo.log_shipping_monitor_secondary
I hope that didn't mess anything up
Mike
FAQ
Search
Profile
Private Messages
Log in
