Before few days I setup a new secondary server for the existing Logshipping setup and found that the Log shipping copy fails to copy the tran log files to the new server.
The issue was that the SQL server and its agent service in the new secondary was running with Local System account, hence did not have the permission to copy the file using IPC. When i changed this to a Domain service account which is the same as in primary server, things started working.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment