false error messag - The log shipping primary database has backup threshold

Question

_{Monday, December 2, 2013 8:16 AM}

i am getting error message as below.

The log shipping primary database <DBNAME> has backup threshold of 60 minutes and has not performed a backup log operation for 19426 minutes.

basically we have migrated our production server and part of migration activity i restored MSDB database from our old server to new server just to retain jobs, mail profiles etc. we have changed the server name & IP to match old server, i checked both primary server and secondary servers back up/copy/restore jobs are running with out any errors, but it throws above mentioned alert on primary.

any suggestions.

Regards,
Praveen D'sa
MCITP - Database Administrator - 2008
sqlerrors

All replies (6)

_{Monday, December 2, 2013 10:56 AM ✅Answered}

Hi,

Thanks for your replies, i found solution through similar issues documented here:

http://social.technet.microsoft.com/Forums/sqlserver/en-US/919473cf-0fe9-436c-aa54-3c45884499dd/lastbackupfile-is-null-in-msdbdbologshippingmonitorprimary

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/894df9bd-c7c2-4ad1-8ed9-681e72521f28/servername-returns-wrong-value-in-sql-server-2008

Regards,
Praveen D'sa
MCITP - Database Administrator - 2008
sqlerrors

---

_{Monday, December 2, 2013 8:27 AM}

Not sure if this helps but as a general rule, I switch off the alert on all my Log Shipping configurations. I've had too many false alerts...

I then use a custom procedure that alerts me if a log backup has not completed within a certain time threshold. Something like this

      
      
CREATE procedure checklogbackups      
@database sysname                  
as     
if not exists (select name from sys.databases where name = @database)    
begin    
print 'Database Does Not Exist'    
return    
end     
else    
                  
if                    
(select DATEDIFF (minute,(select top 1 backup_finish_date from msdb.dbo.backupset                    
where type = 'L'                    
and database_name = @database                    
order by backup_finish_date desc)                    
, GETDATE() ) ) > 120 -- 2 hours                    
begin                    
exec msdb.dbo.sp_send_dbmail                      
@profile_name = 'profile_name',                      
@recipients   = 'recipients',                
@subject      = 'alert message'                     
end                    
else                    
begin                    
print 'Log Backups Running'                    
end 

---

_{Monday, December 2, 2013 8:43 AM}

 did you restore the database on the new server or attached the db

Ramesh Babu Vavilla MCTS,MSBI

---

_{Monday, December 2, 2013 8:46 AM}

i am getting error message as below.

The log shipping primary database <DBNAME> has backup threshold of 60 minutes and has not performed a backup log operation for 19426 minutes.

basically we have migrated our production server and part of migration activity i restored MSDB database from our old server to new server just to retain jobs, mail profiles etc. we have changed the server name & IP to match old server, i checked both primary server and secondary servers back up/copy/restore jobs are running with out any errors, but it throws above mentioned alert on primary.

any suggestions.

Regards,
Praveen D'sa
MCITP - Database Administrator - 2008
sqlerrors

Hello,
Can you check below MS links for above message

http://technet.microsoft.com/en-us/library/aa337318.aspx

http://support.microsoft.com/kb/329133

Hope this helps

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

---

_{Monday, December 2, 2013 9:36 AM}

Hi,

thanks for your reply, i do not have out of sync problem nor do i monitor server, its just two servers Primary & secondary.

Thanks

Regards,
Praveen D'sa
MCITP - Database Administrator - 2008
sqlerrors

---

_{Monday, December 2, 2013 9:38 AM}

Hi,

Yes i have restored all user db's and msdb as well.

Thanks

Regards,
Praveen D'sa
MCITP - Database Administrator - 2008
sqlerrors