Problem:-Log Shipping Is  Not Working Properly Copy Job Failed to connect to server as a Result Copy Job Failed, Copy Job Unable to Retrieve Correspondence Server 

 

Message    *** Error: Failed to connect to server WIN-LRT4KIF4JG5.(Microsoft.SqlServer.ConnectionInfo) ***
  *** Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)(.Net SqlClient Data Provider) ***   ----- END OF TRANSACTION LOG COPY     -----

Exit Status: 1 (Error)


Solution:-


1) Why Copy Job Failed
:- Failed to connect to server WIN-LRT4KIF4JG
 In My Scenario I find that The Host Name(Actual System Name) And Server name which is configured in sql server is Different You Can find In Below Image

As shown In Below Screen Shot  in configuration of sql server server name is WIN-LRT4KIF4JG5

As shown In Below Screen Shot  Host Name is DR1012

System Name

While Executing Copy Job It Fetching Old Server Name,
Sql Server Is Installed Before Changing Host Name,The Master Database Having Record of Old Host Name


How To Resolve This Issue There Are Two Way
1)Simple Change system name as old name and Restart OS

2)Renamed computer that hosts a default instance of SQL

I Have Done in Second Way

sp_dropserver  <old server name>;

go

sp_addserver  <current system name>,local;

Then,restart the instance of sql server

Example in my case
sp_dropserver 'WIN-LRT4KIF4JG5';
go
sp_addserver 'DR1012', local;


After That i Enjoyed !!!!!