Comprehensive Disaster Recovery and Backup Solutions for halFILE Database
Explore various backup services for halFILE database, assess money & time considerations, and determine a multi-tiered backup strategy to ensure data security and minimize downtime in case of disasters. Choose from Bronze, Silver, Gold, or CountyRecords.com Participation services.
Comprehensive Disaster Recovery and Backup Solutions for halFILE Database
E N D
Presentation Transcript
halFILE 2.2 Disaster Recovery & Backups
Money & Time • How much money and time are you willing to spend? • How long can you afford to be down?
Backup • SP_HFWBackup • Stored procedure that now controls halFILE database backups and formats flat files correctly • New databases must be added to the backup in Enterprise Manager • Auto archive includes data backup for current CD only • What images need to be backed up?
Multi-tiered backup strategy • Fault tolerance – expense vs. downtime • Mirror • RAID5 • Hardware vs. Software • Are you protected if one backup strategy fails? • Are you monitoring / testing your backup • Minimum tape rotation (14 tapes) • 2 sets of M-Th • Friday 1-3 • Month 1-3
One-time Backup Service • Check status of in-house backup of halFILE database • Check status of in-house backup of halFILE Images • Create permanent backup of halFILE database • Assist in creating permanent backup of halFILE images • Assist you in learning to monitor your backup
Bronze Backup Service • Weekly off-site backup of halFILE index information • Monitor status of in-house halFILE database backup • Monitor status of in-house Auto Archive
Silver Backup Service • Weekly off-site backup of halFILE index information • Weekly off-site backup of halFILE images • Monitor status of in-house halFILE database backup • Monitor status of in-house Auto Archive • Ship permanent backup on CD when cartridge is filled
Gold Backup Service • Weekly off-site backup of halFILE index information • Weekly off-site backup of halFILE images • Monitor status of in-house halFILE database backup • Monitor status of in-house Auto Archive • Ship permanent backup on CD when cartridge is filled • Remote access through e.halFILE for your staff
CountyRecords.com Participation • All features of Gold Backup Service plus: • Public has access to your records through http://www.countyrecords.com • Share of the profits
Questions? There's no such thing asa bad hug, only good onesand great ones