Database Backup And Disaster Recovery Essay

749 words - 3 pages

A backup and recovery plan is necessary for the databases that the ABC Company uses for its business needs. In the event of a natural disaster, human error, hardware failure, or any other corruption or loss of data, backup and recovery measures will mean the difference between an inconvenience and a catastrophic loss of company data. The following report addresses various options for backup and recovery, and proposes what measures ABC Inc should adopt for its SQL Server 2012 servers.
Database Backup
SQL Server 2012 supports three scopes of backup and an additional special purpose backup type. The first of the three backup types is whole database which as its name implies, backs up the entire database. A partial database backup backs up read/write filegroups “and, possibly, one or more read-only files or filegroups” according to Microsoft (n.d.). File or filegroup backups are conducted on singe file or filegroups. Finally, a copy-only backup is an out of schedule backup that is initiated for a special purpose, and does not affect the normal cycle of backups.
When a backup is conducted, it can be a full backup or a differential backup. A full backup will copy the entire database, while a differential backup will backup only the changes that have been made since the last backup was conducted. Whole, partial, and file/filegroup backups all can be full or differential backups. A copy-only backup can only be a full backup because it does not change the transaction log, and therefore is outside of the scope of routine backups. According to Microsoft, “A copy-only backup cannot serve as a differential base or differential backup and does not affect the differential base” (n.d.).
An online backup is the process of backing up data while the system is active… or online. SQL Server 2012 supports online backups which will be used in the company’s backup plan. Whole, full system backups will be processed daily in the late evenings, when database usage is the lightest. On a continual basis, differential transaction log backups will happen every 15 minutes, which will keep sequential database changes backed up in between full backups. All database backups will use a mirrored media set that saves backup data to an onsite backup server as well as an identical offsite server at one of the company’s satellite offices. The offsite backup provides reasonable assurance that a natural...

Find Another Essay On Database Backup and Disaster Recovery

Types of backup and installation of printers

594 words - 2 pages available in the network appears, click on the one you want then click on next.•Choose default or no then click on next.•When the installation is complete click on finish.Task 2What Is Backup and Recovery?A backup is a copy of data. This copy includes important parts of your database such as the control file and data files. A backup is a safeguard against unexpected data loss and application errors; should you lose your original data

Discuss measures companies need to take in order to prevent computers system failure

982 words - 4 pages software that is economical and easy to use. Don't get caught without your backups. For a large company or enterprises, they usually used centralized backup, which were expensive compare to common type of backup. Some of the centralized backup is, Database Module, Encryption Modules, and Disaster Recovery Option, and Off-Site Storage. Database Module, This software is added to the central backup system so those databases can be backed up while online

Backing up Computer Resources

532 words - 3 pages , (2002). Disaster Recovery Planning. Thomson CourseTechnology.Eric Maiwald, William Sieglein, (2002). Security Planning and Disaster Recovery .McGraw-Hill Professional.Dorian J. Cougias, E. L. Heiberger, Karsten Koop, (2003).The Backup Book. NetworkFrontiers. 

Backing Up Active Directory In Windows 2000

1866 words - 7 pages Disaster Recovery Plan (DRP). One of the procedures commonly included in such a plan is a backup of that server. A backup is a point-in-time copy or image of data, such as a file system, a database, or any data on a mounted logical device.” Creating backups of important data and mission-critical systems on a regular basis can help make sure that your data is protected from an unrecoverable hardware failure that could happen to your system. Typically

How To Create A Disaster Recovery Plan

1834 words - 7 pages . 3. Appoint a disaster recovery team leader for each operational unit, such as server backup or telephone system. 4. Convene disaster recovery planning team and sub-teams as appropriate. 5. Working with senior executives responsible for disaster recovery, the disaster recovery coordinator should identify the following: Scope – the areas to be covered by the disaster recovery plan Objectives – what is worked towards and what

Kugler Foods Disaster Recovery Plan

8162 words - 33 pages consider reassessment of many of the same evaluation areas, which open transition to backup, and recovery activities in preparation for migration back to normal operations. Comparable checklist might be employed to ensure all affected resources and activities are taken into account. While more time may be available for these migration decisions, the decisions are no less difficult. A disaster recovery plan execution checklist will help envision

Kudler Fine Foods: Disaster Recovery/Business Resumption Plan

9814 words - 40 pages membership is a very important step in developing a DR/BR plan. This team is responsible for compiling and updating disaster recovery procedures and distributing the information to the entire company so that all will know how to respond and who to contact in the event of a disaster.The next phase is determining which applications are mission critical to the company's success. In Kudler's case their newly developed vendor managed inventory database

Riordan Manufacturing Business-To-Business Database System

5480 words - 22 pages - One of the key features in database maintenance includes database availability. Databases become unavailable due to downtime, which can come from two sources, hardware and software or application failure. Due to technical advances in hardware and hardware backup solutions, hardware downtime can be avoided by good disaster recovery design, which is addressed in a later section of this paper. The second and larger cause of downtime is application

Oracle Database Analysis

768 words - 3 pages -business departments, and distributed branch environments. It is available on single servers supporting up to a maximum of 2 CPUs. Oracle Database 10g Standard Edition One is available on all Oracle's supported operating systems, including Windows, Linux and Unix.Out of the box, database is pre-configured for production usage, complete with automated space, storage and memory management, automated backup and recovery, and automated optimizer statistics


1021 words - 5 pages information backup and activation of data at the off-site center. The company should have a monthly fire drills and emergency response drill; these drills will serve as a training ground not just for the disaster recovery team, but everyone at the company. Since the BCP is predominantly concerned with the protection of the facility, company information, and customer information. The recommendation will be to have a data redundancy system. The company

The Changing Role of the Database Administrator

1145 words - 5 pages March 1996Technology Changes Roll of Database AdministratorThe database administrator (DBA) is responsible for managing and coordinating all database activities. The DBA's job description includes database design, user coordination, backup, recovery, overall performance, and database security. The database administrator plays a crucial role in managing data for the employer. In the past the DBA job has required sharp technical skills along with

Similar Essays

Understanding Backup And Disaster Recovery Planning

601 words - 3 pages In an emergency situation, securing data is more important than securing money that’s in the building. You can easily recover money lost. But if it’s important data you’ve lost, it may be hard for you to get it back. And the consequences to this can cost you your business. To ensure you have your data protected, it is important to have backup and disaster recovery planning. This will allow your business to make the necessary preparations to

Organization It And Security Systems: Disaster Recovery

1148 words - 5 pages procedures and supply reminders from time to time which will ensure security is a priority. Each system should must condition for data backup as well as recovery. Backup relates to copying data at scheduled intervals, or continuously. Recovery refers to restoring data and restarting a system after it has been interrupted. An overall backup and recovery plan which prepares for potential disasters is referred to as disaster recovery plan. The

Testing And Maintenance Of Disaster Recovery Plans

2307 words - 9 pages may prepare business continuity (BC) and/or disaster recovery (DR) plans to assist in mitigating the negative effects of a crisis. Business continuity involves actions that are carried out by an organizational to ensure critical or otherwise deemed priority operations continue under normal conditions or those in which business operations are degraded by an unforeseen incident (Arduini & Morabito, 2010; Salman Sawalha, 2013). Additionally

Risks And Potential Impact Relating To Security, Auditing And Disaster Recovery

600 words - 2 pages be taken in resolution. Backups may be used to replace lost or damaged files. Impacts to third parties should be kept as minimal as possible during the resolution.BibliographyErbschloe, Michael, and John Vacca. Guide to Disaster Recovery. Cambridge: Course Technology, 2003.Mattord, Herbert J., and Michael E. Whitman. Principles of Information Security, Third Edition. Cambridge: Course Technology, 2008.