Log shipping fails to update metadata tables in monitoring and secondary servers

    Recently I was working with a Customer and came across a situation where log shipping does not update the system meta data table log_shipping_monitor_secondary in monitor server and secondary server in msdb. there is a known issue when SQL agent account does not have permissions to update tables in msdb in monitoring server….


Microsoft SQL Server 2008 R2 Utility Control Point – Multi Server Management

Microsoft SQL Server 2008 R2 Utility Control Point – Multi Server Management In today’s world most challenging question for SQL Server DBA is how to monitor our database environment Ø Hundreds of databases Ø Most databases have a single Database File and one Transaction Log file Ø CPU and Storage is a major pain area…

1