SQL Server Performance

Logshipping from one server to another

Discussion in 'SQL Server Log Shipping' started by pushkar_anand, Feb 23, 2006.

  1. pushkar_anand New Member

    hi
    in log shipping we are taking backup for data as well as log files in local directory in a particular server.

    can u advice me if i have done maintenance plan in one server and want the data and log to be store in the directory of different server. How can we do it in SQL server 2000 with SP-3.
    Thanks
    Pushkar Anand
    pushkar_anand, Feb 23, 2006
    #2

  2. hema.bugatha New Member


    If we use the maintenance plan..we can't do that..I did it on the server...
    hema.bugatha, Mar 15, 2006
    #2

  3. satya Moderator

    Its better to use scripted log shipping than using maintenance plan.
    You can schedule another job to pickup those backup files from secondary server to the target server.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Mar 15, 2006
    #2

Share This Page