Robo Copy command to transfer sql server logshipping files RRS feed

  • Question

  • Hi Experts
    I want to Copy log shipping files between primary and secondary servers.
    Can some one help in providing the robocopy command for copying the files on to secondary server.There is no other go except roby copy as i have network related issues.

    As a known fact, the logshipping file names will be dynamic with the datestamp included in the filename.

    It has to pick only the files which are not existing on the secondary server.

    This process to be scheduled in sql server agent.
    Windows server 2003 and sql server 2k5


    Tuesday, November 24, 2009 3:57 PM

All replies