Log Shipping – Copy and Restore job failing with no error message

-> I was setting up log shipping to ship transaction logs from our primary server to Disaster Recovery server.

-> Log Shipping setup completed fine without any errors. But the SQL Server agent jobs for Copy and restore job were failing with no meaning full message. Below message was found in SQL Server agent history,

Executed as JBS\jvivek2k1

-> I opened the copy job and added an ouput file to the step and started the job again. The job failed and the output file was blank.

-> I opened the copy job again and copied the content of the copy job which basically calls sqllogship.exe and executed in a command prompt and got below message,

The following feature couldn’t be installed : .NET framework 3.5 (includes .NET 2.0 and 3.0)

Windows Server roles and features cannot be automatically installed or uninstalled via the Windows Features Control Panel.

To Install Windows Server roles and features, start Server Manager, or use the Server Manager cmdlets for Windows PowerShell.

-> I installed .NET 3.5 manually and rebooted the server. This solved the issue.

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.