Improve company productivity with a Business Account.Sign Up

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

How do I disable log shipping monitor alerts for a database that has been deleted in SQL Server 2005?

I have a pair of SQLServer 2005 servers with replication between them that is working fine. However while working out how to do this we created a test database and got replication going on that. This test database has since been deleted, but every two minutes an error appears in the log saying that 'log shipping primary database [database name] has backup threshold of 60 minutes and has not performed a backup log operation for xxxx minutes. Check agent log and logshipping monitor information.'

how do I turn off these alerts for this now deleted database?

many thanks
0
rogcoleman
Asked:
rogcoleman
  • 2
2 Solutions
 
James MurrellProduct SpecialistCommented:
IN Maintenance Plan. Right-click the Maintenance Plan, and then click Properties. Click the Log Shipping tab and remove the one that mentions your old db
0
 
rogcolemanAuthor Commented:
Thanks for your suggestion.

Unfortunately there are no plans listed under 'maintenance plan'

I'm going object explorer -> [my database] -> management -> maintenance plans

when I right click I get 'New Maintenance Plan' or wizard, view history, reports or refresh
0
 
rogcolemanAuthor Commented:
Hi,

Hi have fixed this now.

There are two things that I did which may have fixed it -

firstly on the secondary server I deleted the test database, then on the primary server I deleted all the rows from the log_shipping tables in System Databases -> msdb -> System Tables (there were lots)

that seems to have fixed it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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