Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

Edit log shipping primary alert

Sql 2012 Std.
One of our databases was renamed prior to deleting the log shipping setup.  Now the 'Log shipping Primary Server Alert' sends a 14420 alert every few minutes complaining that <olddatabasename> has not performed a backup log operation.  Looking in management studio under 'alerts-logshippingPrimary...' I can edit the job to check all databases, or ONE specific database. I do not want to create a custom alert check  job for each DB.  How do I remove the old dbname from the list of names being checked?
0
billherde
Asked:
billherde
  • 2
1 Solution
 
billherdeAuthor Commented:
Figured it out.

First back up MSDB

Verify backup of MSDB

then

Attach to the msdb database and run query
Select * from msdb.dbo.log_shipping_monitor_primary

From results get the primary_id of the db with the problem and insert it in the appropriate place on the following query.

begin tran
delete from msdb.dbo.log_shipping_monitor_primary
where primary_id='FC6F41C1-0697-4354-BBDF-615A4AD1BC10'
rollback tran

Run check first to make sure only ONE colum is affected, then execute.
0
 
billherdeAuthor Commented:
Note
Running query as above will check without making changes.
Remove the begin tran and rollback tran lines to make it happen.

Verify results with select query.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now