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.
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_period9C843969-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 2880How 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 |
|
|
|
|