Log Shipment failure for data above 5GB.

Question

We have a Log Shipping Setup having 2 instances of :

• Microsoft Windows Server 2012 R2 Standard
• with MS SQL server 2014

We have MS SQL EKM installed on both the servers with TDE enabled on them.
Both the setups are connected to same Key Managers(HA).

While running backup of 10MB of data, log shipment works perfectly fine, but if the data reaches 5GB or 10GB, the backup of log shipment fails.

• With low Data: Log shipping works fine if 1 Key Manager is up or both are down. Both Backup and Restore are successful.
• With large data: Log shipping works fine if 1 Key Manager is up. If both Key Managers are down, even the backup job fails.

We checked there was no restart of the SQL service when the backup job was running and failed.

Answer 1

Hi,
Please provide the detailed error information when the backup job fails for further research.

Best regards,
Mico Mi

Answer 2

Thanks for the prompt response @Mico Mi .

Attaching the snippets and logs.

45099-log00.txt45100-log01.txt

45251-log02.txt45252-log03.txt45223-log04.txt45233-log05.txt45242-log06.txt45271-log07.txt45214-log08.txt45215-log09.txt45224-log10.txt45281-log11.txt45204-log12.txt45282-log13.txt45225-log14.txt45216-log15.txt45166-log16.txt45205-log17.txt

Answer 3

45236-log18.txt45148-log19.txt45169-log20.txt45170-log21.txt45272-log22.txt45127-log23.txt45273-log24.txt45263-log25.txt45019-log26.txt45254-log27.txt

Answer 4

Hi,
I found a lot of 14420 errors in your logs, you can check the following link and see if it could help at your side:
https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-14420-database-engine-error?view=sql-server-ver15
Thanks for your time!
Best Regards,
Mico Mi

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

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.