LS_Alert job failing because of a non-existing database

• Paresh Motiwala

  SSCommitted

  Points: 1772

  More actions

  August 17, 2015 at 1:00 pm

  #299779

  I have a database called Paresh_Temp.

  I created to prove a concept and deleted the database and its associated backup/copy/restore job pertaining to Log Shipping.

  The LS_Alert still thinks that the db is missing and hence fails.

  Any idea, how to resolve this?

  Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA

• Perry Whittle

  SSC Guru

  Points: 233854

  More actions

  August 19, 2015 at 2:14 pm

  #1821196

  did your LS setup specify a monitor server?

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉