SQL Server Performance Forum – Threads Archive
Log file CopyI have setup log shipping, and for some reason the logs from the source server are not getting sent over to the destination server. So I am only in sync for 15 minutes after setting up log shipping, after that the secondary server never gets any logs. Any ideas would be greatly appreciated. First time setting this up, so I could be missing something obvious, both SQL agents are running under the same domain account.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx Check the above articles and findout which part was missed where the log backup file is not copied between primary and secondary SQL servers. Check the maintenance plan log for complete information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
You need to check the owner of the Copy job and the permissions for the same.
Try to manually copy the files using the same user. If its working then there is no permissions problems. -Anup