|
csaha
Yak Posting Veteran
52 Posts |
Posted - 02/26/2013 : 12:01:03
|
exec master..sp_help_log_shipping_monitor_primary @primary_server = 'primaryserver', @primary_database = 'AbraHRMS_Live'
primary_id primary_server primary_database backup_threshold threshold_alert threshold_alert_enabled last_backup_file last_backup_date last_backup_date_utc history_retention_period 9C843969-8485-4D08-8DAD-A2D3D209D041 primaryserver AbraHRMS_Live 60 14420 1 NULL 2012-12-14 18:50:20.910 2012-12-15 00:50:20.910 2880
How do I delete the the row in the msdb database, which table should I choose from the msdb database? Is it db0.logshipping_primary_databases |
|