共用方式為

SQL Server 2016 Log Shipping Jobs Fail Silently

  • 發行項

Lately found out a solution to a very strange SQL 2016 Log Shipping issue: its LSBackup_<db name> job fails without any meaningful error message.  Nothing will show in SQL or Windows log. When you check its job history, you will see the job failed with below message:

Date  <date time>
        Log  Job History (LSBackup_<db name>)

        Step ID  1
        Server  <server name>

        Job Name  LSBackup_<db name>
        Step Name  Log shipping backup log job step.
        Duration  00:00:00
        Sql Severity 0
        Sql Message ID 0
        Operator Emailed 
        Operator Net sent 
        Operator Paged 
        Retries Attempted 0

        Message
        Executed as user: <domain\user>. The step failed.

Turns out the fix to this issue is either install .NET Framework 3.5 feature on the Windows server running SQL 2016 or install SQL Server 2016 CU1.

Please refer to https://support.microsoft.com/en-us/kb/3173666 for detailed information regarding how to get the CU. The link is for solving a different but related issue (LSCopy job fails).

This fix was tested on Windows Server 2012 R2 and Windows Server 2016.