Orange County NC Website
Browse       Search
DocuSign Envelope ID:8D6BF819-7F7F-492F-B590-6156F7327668 <br /> RECOMMENDED BACKUP PROCEDURES <br /> Developing a consistent backup strategy is a vital part of any organization's business continuity plan.A good <br /> backup plan ensures that you do not lose the hard work and time you invested in data entry if a hardware failure <br /> or natural disaster occurs.A plan such as this is easy to develop and usually easy to implement.This section <br /> outlines the steps you should take to properly back up your data. <br /> Assessing Your Backup Needs <br /> Backups occur differently,depending on the size of the database being used. The differences directly impact how <br /> quickly you can resolve problems and how much effort you must expend. Tyler recommends that you implement a <br /> backup plan based on the point values determined in your initial Site Assessment. <br /> Rotating Tapes <br /> First,establish a good tape rotation for your backups.Tyler recommends that you use,at a minimum,the following <br /> 6-tape rotation: <br /> M T W Th F1 <br /> ITTM <br /> M T W Th F2 <br /> This rotation is sufficient for most customers because you can go back a few business days to find files. However, if <br /> you feel you need a little more protection,you can use a different set of tapes for Mon-Thurs of Week 2,and/or <br /> you can keep a Fri 3 and Fri 4 tape so that you have a month's worth of Friday backups.We also recommend that <br /> you periodically(monthly,quarterly,etc.) pull a tape permanently out of rotation to store off site <br /> Backing up Your SQL Database <br /> For EnerGov,the default databases should consist of at least FY databases, Base,Sec and State database. <br /> There are a few different methods for backing up your SQL database. <br /> • SQL Backup Function:The Microsoft SQL Server 2008 R2 Management Studio has built-in backup tools <br /> that can cause SQL to dump the EnerGov database to a backup file in the SQL default backup folder while <br /> the SQL services are running.This location is: <br /> C:IProgram FilesiMicrosoft SQL ServeriMSSQLISackvpI <br /> • Third-Party Backup Agent: This method requires that you have some sort of third-party backup <br /> program (e.g., Symantec Backup Exec, Brightstor ARC Serve, etc.) which uses a SQL backup <br /> agent. These special backup agents allow the Microsoft SQL databases to be backed up while they <br /> are online. <br /> • The Microsoft SQL Server installation path may vary slightly per installation. <br /> EnerGov Solution System Requirements 5 <br />