Post reply

SQL SERVER 2000 DTS or Script

  • October 8, 2008 at 12:22 pm

    #213850

    Hi guys,

    I need to copy the latest backup file from one server to another server and restore there daily and automatically. Can you provide some ideas or scripts to handle this task

    Thanks

    Ashok

  • October 8, 2008 at 12:26 pm

    #882506

    Here's a great example. This includes a comprehensive log-shipping solution, but you can pull out the full backup/restore pieces. I've implemented this at a place that has not been running it for about 1year without a hitch.

    http://www.sqlservercentral.com/articles/Administering/customlogshipping/1201/

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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