SQL Server Performance

Log file Copy

Discussion in 'SQL Server Log Shipping' started by duhaas, Sep 9, 2004.

  1. duhaas New Member

    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.
  2. satya Moderator

    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.
  3. anupchintawar New Member

    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

Share This Page