The .NET Framework 3.5 is required when you configure SQL Server 2016 as a secondary in Transaction Log Shipping

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Standard

Symptoms


Consider the following scenario:
  • You install SQL Server 2016 on your computer.
  • You use Transaction Log Shipping and configure SQL Server 2016 as the secondary.

In this scenario, when you start a LSCopy job on the secondary, you may encounter failure without an error logged.

If you edit the LSCopy job under SQL Server Agent on the secondary, copy and paste the full sqllogship.exe command in the command line and then press Enter, the .NET Framework 3.5 is listed as being required.

Note After you install the .NET Framework 3.5 and restart the server in this scenario, the LSCopy and LSRestore jobs run correctly.

Resolution


The fix for this issue is included in the following cumulative update for SQL Server:


Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology Microsoft uses to describe software updates.