状况:在两台服务器上配置了Log Shipping,误删除辅助数据库和备份还原作业,导致Log Shipping不可用,且无法通过Log Shipping配置界面Disable Log Shipping,报错。
处理方法:在主服务器上的msd数据库中,有关于Log Shipping的系统表,如下:
select * from log_shipping_monitor_alert
select * from log_shipping_monitor_error_detail
select * from log_shipping_monitor_history_detail
select * from log_shipping_monitor_primary
select * from log_shipping_monitor_secondary
select * from log_shipping_primaries
select * from log_shipping_primary_databases
select * from log_shipping_primary_secondaries
select * from log_shipping_secondaries
select * from log_shipping_secondary
select * from log_shipping_secondary_databases
其中,log_shipping_primary_databases和log_shipping_primary_secondaries 存储的是Log Shipping主数据库配置信息,删除表中的对应记录,即可取消之前的Log Shipping配置。