SQL Server Performance Forum – Threads Archive

Log file Copy

I 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.sql-server-performance.com/sql_server_log_shipping.asp
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
Moderator
http://www.SQL-Server-Performance.Com/forum
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

]]>