Backing up to Secondary Server with Automatic Standby
I have 2 x SQL 2005 Servers (Primary + Secondary) both running SQL Backup 5.
I want to have the Secondary SQL Server have a standby copy of the Primary Database restored on a schedule.
How can I do this? It would be very helpful for DRP.