<div>
Thanks for your suggestion.<br />
<br />
Unfortunately there are no plans listed under 'maintenance plan'<br />
<br />
I'm going object explorer -&gt; [my database] -&gt; management -&gt; maintenance plans<br />
<br />
when I right click I get 'New Maintenance Plan' or wizard, view history, reports or refresh
</div>


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

<div>
<div class="content wysiwyg-content">
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.'<br />
<br />
how do I turn off these alerts for this now deleted database?<br />
<br />
many thanks
</div>
</div>


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

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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.