SQL Log shipping

Hi

I have two new SQL Server in SQL SERVER 2008R2. I had activated LOG SHIPPING on my Main Database. The step LSBackup on the main server is working well. On the second server the LSCOPY step is not working. Returns with this error.

*** Error: Could not retrieve copy settings for secondary ID 'fa5f04a7-0423-41ea-b014-02ea10e681bf'.(Microsoft.SqlServer.Management.LogShipping) ***
2015-10-20 15:50:01.33      *** Error: The specified agent_id FA5F04A7-0423-41EA-B014-02EA10E681BF or agent_type 1 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provider) ***
2015-10-20 15:50:01.34      *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2015-10-20 15:50:01.34      *** Error: The specified agent_id FA5F04A7-0423-41EA-B014-02EA10E681BF or agent_type 1 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provider) ***
2015-10-20 15:50:01.34      *** Error: Could not cleanup history.(Microsoft.SqlServer.Management.LogShipping) ***
2015-10-20 15:50:01.34      *** Error: The specified agent_id FA5F04A7-0423-41EA-B014-02EA10E681BF or agent_type 1 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provider) ***
2015-10-20 15:50:01.34      ----- END OF TRANSACTION LOG COPY     -----

Is there somebody who knows how to fix this issue? I didn't find nothing onto Google.

Thanks
jpmoreauAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Koen Van WielinkBusiness Intelligence SpecialistCommented:
While not too complicated in its configuration, setting up log shipping correctly can be tricky. I learned through trial and error and needed a few attempts to get it going.
There's a question from last year that explains in detail how to set up log shipping on MSSQL 2008R2:

SQL Server disaster recovery

Have a read through the steps and follow the instructions on technet and the comments provided. If you do it in the right order, log shipping should work just fine. It's probably quicker to just reconfigure it rather than trying to repair a faulty log shipping setup.
jpmoreauAuthor Commented:
I had reconfigure the log shipping with all the right settings and still the same problem.
Koen Van WielinkBusiness Intelligence SpecialistCommented:
Did a quick Google on part of the error message, and others report that insufficient rights for the user that is used to run the SQL Server Agent service might be the issue. Make sure this is a domain user who has privilege on both servers.
Another reported solution has to do with the -server parameter in the copy and restore job commands. Have a look at both of these jobs, and make sure that the parameter for -server points to the SECONDARY server. Apparently sometimes this goes wrong and it points to the primary. This would be the parameter for sqllogship.exe.
jpmoreauAuthor Commented:
What do you mean by -server
Koen Van WielinkBusiness Intelligence SpecialistCommented:
The sqllogship.exe file takes a parameter called server which should be filled with the secondary server name. So in the command sqllogship.exe -server, replace -server with the correct server name.
MSSql will auto create this command as a job, but what I read was that in some cases it would fill the primary server name instead of the secondary server name. That produced the same error you're reporting.
So check the log shipping jobs, look for the part where sqllogship.exe is called, and make sure the server parameter points to your secondary server.
Hope this clarifies.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.