Copying useable databases to a Bacup SQL server
I am an Access developer teaching myself SQL Server 2005 (but very new to SQL Server). I am trying to do something that sounds simple but has not been easy for me: backup the databases on a production SQL server 2005 to a backup server (so I can switch to it if the production goes down). Can I do this w/ SQL Backup 5? How? Many thanks.