Hi all , I am trying to setup custom logshipping in our environment. I would highly thankful if someone share the script for this. I just need the script to continiously resotre the transactional log backups from productionserver to standby server. I have manually done full backups, now i just a script to restore the transactionl log backups. Thanks
Refer http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx this will work on 2000 version too.