Wednesday, 22 January 2020

MS SQL Server 2016, Log shipping stopped due to LSN chain break [TYPE=DISK: {'NUL'}]

In our production database have configured Log shipping. One day Log shipping stopped and found the below message in a log file.


Log was backed up. Database: model, creation date(time): 2003/04/08(09:13:36), first LSN: 42:3512:1, last LSN: 42:3632:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'NUL'}). This is an informational message only. No user action is required.


It was a strange phenomenon as "DISK: NUL found in error message. Since our whole infrastructure under VEEAM backup and after digging into it, I found that "VEEAM -Application-Aware Processing" feature, which creates transactionally consistent backups of MS SQL Server.

As soon as we disabled this feature and log shipping running smoothly.

Hope this will help :)

No comments:

Post a Comment