Old test database still in configuration

Category: sql server mirroring

Question

Hans van Deursen on Tue, 08 May 2018 05:59:24


Hi all,

We have a SQL mirror for Skype purposes. Before installing Skype f B, we did some testing in failover and we used a test DB for that. After the test was completed we removed the test DB. Now SQL still gives errors saying "The log primary shipping database has backup threshold of 60 minutes and has not performed a backup. "

How to solve this issue?

Replies

Shanky_621 on Tue, 08 May 2018 07:57:46


Hi all,

We have a SQL mirror for Skype purposes. Before installing Skype f B, we did some testing in failover and we used a test DB for that. After the test was completed we removed the test DB. Now SQL still gives errors saying "The log primary shipping database has backup threshold of 60 minutes and has not performed a backup. "

How to solve this issue?

I think you are talking about log shipping not database mirroring, that message is related to log shipping and since you abruptly deleted database it is not removed properly it seems ? Please confirm about mirroring/ logshipping

Hans van Deursen on Tue, 08 May 2018 08:04:21


Yes thats correct

Shanky_621 on Tue, 08 May 2018 08:16:36


Yes thats correct
Log onto primary server and expand the job, there you would see LS_XX jobs delete them since you have removed the LS they are not required. Similarly log onto secondary and delete the LS_XX jobs