100 likes | 118 Views
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.
E N D
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