What are the challenges you face when working across database platforms? Take the survey
Options

How do you archive your backups?

maddavemaddave Posts: 28
edited August 12, 2014 11:13AM in SQL Backup Previous Versions
This isn't really a support question, but more a general "how do you do it" type query.

In our organisation we use Redgate backup. We backup 17 SQL instances with a total of about 150 databases across these instances. Redgate Backup is configured to do a full backup of each of these databases every night and 15 minute log backups, which is writes to a central server so that the data is off the local servers. After 7 days, the oldest files are deleted by Redgate Backup.

This results in around 3 terrabytes of data on the central server. Each Friday, we use Backup Exec to write this data to tape, so that it can be archived and stored offsite. This process is repeated monthly and yearly, so that we can restore data from up to 3 years ago.

The problem is, we are having issues getting successful backups of the 3TB of data onto tape. The jobs regularly fail and we think it is due to the fact the the redgate backups change so frequently. The Backup exec jobs takes a while to run, during which a number of log backups could have taken place so older files would have been deleted and now no longer exist for backup exec to read.

I would be interested in what people do to archive their database backups and how they secure long term backups offsite in the most efficient and resilient way.

Any help would be great.
Sign In or Register to comment.