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
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.