SQL Server Performance Forum – Threads Archive
Logshipping from one server to anotherhi
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.
If we use the maintenance plan..we can’t do that..I did it on the server…
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.