Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Logshipping error

Author  Topic 

csaha
Yak Posting Veteran

52 Posts

Posted - 2013-02-26 : 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
   

- Advertisement -