title: Transaction log shipping backup job remains after deleted database
body: <p>I have been a lurker for several years and I <strong>think</strong> I have a question that hasn't been answered here. </p>
  
  <p>We were in the middle of some pretty intense maintenance on or SQL server last night. Or primary database mdb file was very badly fragmented. We maintain a test copy of this database for testing and proof of concept purposes. </p>
  
  <p>I had setup log shipping on the test database and without thinking I deleted the test database without removing the log shipping first. I am getting error 14421 - The log shipping secondary database SERVER.database has restore threshold of 45 minutes and is out of sync. No restore was performed for 10310 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information.</p>
  
  <p>I have removed everything I could with tsql. My research leads me to believe that this error is due to the backup job still trying to operate but I cannot find this job to remove it. It's really not a big deal but the error shows up every couple of minutes in the log. </p>
  
  <p>Is there anything I can do?</p>
  
  <p>Thanks in advance!</p>