Hi,
When I ran the Xp_cmdshell 'dir \\Server1\infDB' in Server2, receiving the output i.e drive details;
But, It's showing output as "Access is denied" ;
when I ran Xp_cmdshell 'dir \\Server1\E$' in server 2 and Xp_cmdshell 'dir \\Server2\E$'
in Server1.
I have assigned full control permission for 'everyone','serviceaccount','sqlserver agent' on the folder in both servers but still facing the issue "Copy job is getting failed"
ERROR:
*** Error: Could not retrieve copy settings for secondary ID '6a9d5c80-52c1-491e-87ce-379cd13190ed'.(Microsoft.SqlServer.Management.LogShipping) ***
2012-05-08 05:30:59.77 *** Error: The specified agent_id 6A9D5C80-52C1-491E-87CE-379CD13190ED or agent_type 1 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provider) ***
012-05-08 05:30:59.85 *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2012-05-08 05:30:59.85 *** Error: The specified agent_id 6A9D5C80-52C1-491E-87CE-379CD13190ED or agent_type 1 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provider) ***
2012-05-08 05:30:59.87 *** Error: Could not cleanup history.(Microsoft.SqlServer.Management.LogShipping) ***
2012-05-08 05:30:59.87 *** Error: The specified agent_id 6A9D5C80-52C1-491E-87CE-379CD13190ED or agent_type 1 do not form a valid pair for log shipping monitoring processing.(.Net SqlClient Data Provider) ***
2012-05-08 05:30:59.87 ----- END OF TRANSACTION LOG COPY -----
Exit Status: 1 (Error)
Please advice.
Thanks and Regards,
Ravi.