How do I disable log shipping monitor alerts for a database that has been deleted in SQL Server 2005?
Posted on 2009-05-13
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?