Backup and recovery of Large databases

I am the Senior System administrator/DBA of a Sequent SE60.We have a large database of 40Gb which has to be highly available. At present we run hot backups 6 nights a week and run archiving. A cold backup is run on a Saturday night.These backups take about 4 hours (not bad eh?) using 4 * 10GB (compressed) Exabyte tape drives and PTX/Backup. My problem is this:

        I have tried to recover the database on another machine,to test disaster recovery.The restore is still running and by my calculations is going to take about 42 hours!.How are you other DBA's backing up and recovering your large databases and how long do they take?

Thanks

Carl Churchman
carl_at_carlc.demon.co.uk Received on Fri Oct 07 1994 - 20:58:44 CET