I have a brand new SQL Server 2005 with a few 5GB databases. In my main database I want to set up backups at 01:00 every day, a full backup nightly.
When the full backup occurs at night I would like to have it copied and restored to another server which will be far away from the head office on our network
So I’m asking if any one have the knowledge on that or if there is any script for that

Thank you-