I am looking into the possibility of keeping a "warm" spare of my Prod DB on my backup server. I would like to synchronize them only twice a day and don't think I need to implement a full complex log shipping solution. It would suit my needs to just do the following steps twice a day: Backup my prod DB Copy the prod DB to my backup server Restore the prod DB on my backup server. What process would I go about automating or scripting this the best, or easiest way? Can I use Batch scripting? Should I use VB? Can I use scheduled utilities or procedures in SQL Server? Should I use a third party tool such as LiteSpeed? Any input/code is appreciated.