Post reply

Help - LogShipping - Data does not change on Secondary Server

  • April 14, 2004 at 3:38 pm

    #84800

     

    Hi,

    I have configured Log shipping by following the steps mentioned on technet article.

    But, I do not see the data getting changed on the secondary server, I do see the physical transaction log backups on the primary server, and Log shipping monitor does not show any errors.

    The copy of transaction log backup from primary to secondary server and the restore is not happening.

    Please let me know how should I go about in fixing this problem

    Both the Primary and Secondary server are running SQL2k Enterprise Edition with latest service packs and Sqlserver and SqlserverAgent are using domain account for startup.

    Thanks in advance

     

    Sanjeev Kumar

     

     

     

     

     

     

     

  • April 15, 2004 at 6:12 am

    #502895

    Because the copy jog is failing, make sure that you are backing up the log to a share that the secondary has rights to. You should be able to browse that folder from the secondary server and see the log files.

    This is a very detailed article that points out a few gotcha's to look out for.

    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx

     

  • April 15, 2004 at 10:55 am

    #502988

    Thanks , The article was very helpful. I was able to fix the problem .

    Thanks again

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply