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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s