Case Study: SQL Safe Backup

An Insurance Company Turns to IDERA for Reliable Database Recovery

Overview

An insurance provider with more than 5,000 employees and 50 million policy holders worldwide employs 12 database administrators and 300 developers in its Database and Support Services team. This group manages the corporation’s relational database environment consisting of Oracle for Linux, DB2 for z/OS and 2,100 SQL Server databases, which support a wide variety of business critical applications.

Challenge

The database team was struggling with its backup solution for years due to an unacceptable and erratic failure rate of weekly full backups, daily differential backups and hourly log archive backups. The team received false positives on some backups while others they believed were successful did not actually create usable backup files. Also, the poor failure rates would have been even worse if they had included backups that were never even submitted because the previous backup was not finished in a timely fashion. The false positive events were discovered when they attempted to recover a database and a full backup file was missing. They knew they needed to address this situation… quickly.

Topics : Database Administration,Database Backup,

Products : SQL Safe Backup,