locked
log shipping alert job showing error 14220 RRS feed

  • Question

  • hi ..

    pls help me to resolve this issue

    my database is already deleted and there  is no job are running for  that database .previously we configure a log shipping for that database  and deleted.log shipping backup job also deleted.the log shipping alert job is throwing bellow error.

    The log shipping primary database tes1 has backup threshold of 60 minutes and has not performed a backup log operation for 132722 minutes. Check agent log and logshipping monitor information.

    regatds

    Gani

    Wednesday, June 3, 2015 9:44 AM

Answers

  • This is because what you did is incorrect way of removing log shipping. You need to remove it completely a quick workaround is to disable Alert jobs. Log on both primary and secondary servers and you wuld see LS_Alert job disable on both machines

    Please use below link to remove logshipping

    https://msdn.microsoft.com/en-us/ms189071.aspx?f=255&MSPPError=-2147217396


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Wednesday, June 3, 2015 10:11 AM
    Answerer
  • Did you read carefully what Shanky has said? You need to disable  the alert job so that it wont alert. It is not possible if you have other log shipping enabled databases.

    You are getting the error because there are still entries in the log shipping tables about the database that you deleted.

    Check these tables log_shipping_monitor_primary & log_shipping_monitor_secondary and see if you can find the deleted database references. If so you might have to delete those rows. These tables are in msdb. Take proper backups before you do any such operations to be in safe side.


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com


    Wednesday, June 3, 2015 10:42 AM

All replies

  • This is because what you did is incorrect way of removing log shipping. You need to remove it completely a quick workaround is to disable Alert jobs. Log on both primary and secondary servers and you wuld see LS_Alert job disable on both machines

    Please use below link to remove logshipping

    https://msdn.microsoft.com/en-us/ms189071.aspx?f=255&MSPPError=-2147217396


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Wednesday, June 3, 2015 10:11 AM
    Answerer
  • dear ...

    i already deleted the database  ... there no database in ssms... but i am getting error in error log  like

    The log shipping primary database tes1 has backup threshold of 60 minutes and has not performed a backup log operation for 132722 minutes. Check agent log and logshipping monitor information.

    now how can solve this issue

    regards

    gani

    Wednesday, June 3, 2015 10:37 AM
  • Did you read carefully what Shanky has said? You need to disable  the alert job so that it wont alert. It is not possible if you have other log shipping enabled databases.

    You are getting the error because there are still entries in the log shipping tables about the database that you deleted.

    Check these tables log_shipping_monitor_primary & log_shipping_monitor_secondary and see if you can find the deleted database references. If so you might have to delete those rows. These tables are in msdb. Take proper backups before you do any such operations to be in safe side.


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com


    Wednesday, June 3, 2015 10:42 AM