Log Shipment failure for data above 5GB.

GUPTA Deepika 1 Reputation point
2020-12-02T06:43:28.113+00:00

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.

Windows Server Backup
Windows Server Backup
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Backup: A duplicate copy of a program, a disk, or data, made either for archiving purposes or for safeguarding valuable files from loss should the active copy be damaged or destroyed.
464 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mico Mi 1,921 Reputation points
    2020-12-03T02:49:21.24+00:00

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

    Best regards,
    Mico Mi

    0 comments
  2. GUPTA Deepika 1 Reputation point
    2020-12-04T11:47:07.543+00:00
    0 comments
  3. GUPTA Deepika 1 Reputation point
    2020-12-04T11:52:37.757+00:00
    0 comments
  4. Mico Mi 1,921 Reputation points
    2020-12-07T09:08:30.047+00:00

    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://video2.skills-academy.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.

    0 comments