SQL SERVER 2000 DTS or Script

• AKP

  SSCommitted

  Points: 1753

  More actions

  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

• John Rowan

  SSC Guru

  Points: 56440

  More actions

  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