Database Backup And Disaster Planning
This research paper is about the backup of Database, the planning of Disaster and the significance of the integration of both the database backup and disaster planning when both are not executed effectively. The report is divided into several sections which discuss the importance of data backup and planning of disasters and the combination of both. A disaster is an event which is uncertain and has a dangerous outcome. Disasters are manmade as well as natural.
A plan of Data recovery can be compared to having an insurance which feels great when we own it but no one wants to use it. No one hopes to use it. For the recovery of disasters, a disaster recovery plan is needed with a site in which all the procedures are carried out. (Mullins C. S., 2016)
By Database backup we mean the process of taking a backup of the data, which means storing the data for the future use. It involves creating a copy of all the data and materials which can be used if the main copy of the data crashes. It basically means creating a copy of the entire database. (techopedia, 2016) The important material is stored at some other location, other than the location of main data. Database backup aims at providing the security against the loss of main data, when an unexpected loss of the data occurs at that time the backup data will be retrieved and used. So, recovery is the main purpose of the database backup. It is also used in retaining the data for longer periods of time.
But it is very important yet tough to decide that which data should be kept in backup because only the significant data is kept in the database. So it becomes very complicated that which one is to be kept in backup and which data should not be. The storage efficiency should be good to store good amount of data. The storage should be restructured and data repository can help in the structuring of database storage. Data storage devices are available in many forms also. These devices are arranged in many forms so that the data can be secured, transportable and convenient. (Mullins C. S., 2016)
Before transferring the data to the storage devices, the selection of the data is done. After selecting, the extraction of data is done from the huge amount of data and then the data is manipulated. The data can be optimized through many ways like rearranging the files, duplication, de-duplication, encryption, etc. The data should be validated and its reliability should be checked by understanding all the related factors.
The companies made a very huge investment on the systems and, maintaining those systems and their security. It is very crucial for the data, the important data to be managed properly to bring success to the organisation. (Gorman, 2014) A backup plan is to be created to make the important data to be secured. It includes following steps:
- Firstly, it is to be decide that what is to be backed up
- Secondly, the backup type should be selected for the different types of data.
- Then, the backup timings, schedule and method should be established properly
- Then, it is to be decided that where the data should be stored for taking a backup
- The backup retention policy is must to be decided.(Bartkowski, Buitlear, & Kalicki, 2012)
Forms of Database Backup
The database backup is of two types which are explained below:
- Logical backup- By logical backup we mean that the data which is stored is logical which is stored through procedures and more and they act as a supporter to the physical backups.
- Physical backup- By physical backup we mean the data is physical which comes from the main database through recovery management.(Phillips, 2011)
Database backups can be divided into following parts in the terms of consistency, which are:
- Consistent backup-In consistent backup the files of database are stored and backed up at a point of time with all the changes made. The explicit recovery implementation is not needed in consistent backup method.
- Inconsistent backup- In inconsistent database backup, the database is stored when there is an abnormal shutdown or any other abnormal activity like if the database is open for all the time then the database backup procedure is meant to be inconsistent database.(microsoft, 2008)
When more files of database are damaged in physical form then the media recovery technique is followed. The reason of the physical damage of database can be the user level errors or the hardware errors. For having the backup of the entire database including the data files, the Total media recovery techniques are used and the Partial media recovery technique is used only for the database and not for the other recovery files.
When some of the block or part of data files will be damaged physically then block media recovery form will be used to improve the situation. The physical damage to the database is caused by several reasons like the failure of hardware, failure of disk controller, Input/output error in the Operating Systems, etc. When the Block media recovery technique is used, the database which is not damaged is available for use during the whole process of recovery. (techopedia, 2016)
The recovery from the potential disasters is very important. (microsoft, 2008) For recovering teh databases from the disasters, a well designed data backup plan is essential. A data recovery plan is essential for assuring that all the data is been stored properly and quickly. The data recovery is all about the collection of the process and policies which assist the organisation to sustain the business even in some worst conditions of disasters which can be manmade or natural disasters, but disaster planning helps in preserving the data and recover it with the help of the information systems of the organisations and through technologies. (Bartkowski, Buitlear, & Kalicki, 2012)
These disaster recovery systems keep the continuity of the business and make it safe from any threat. The disaster recovery can be done through various measures in an organisation. The disaster recovery plan involves planning for the data, application of the communication process, hardware and the infrastructure, etc. it also contains some of the non Information technology factors which are significant for the business of an organisation. Like reputation management, facilities, personnel, etc. (Phillips, 2011)
The Disaster Recovery Controls are of following types:
Preventive controls and measurements: These are used to prevent any activity from occurrence.
Detective controls and measurements- These are used to detect any activity which is not wanted to occur in the organisation.
Corrective controls and measurements– These are used to recover the system when any error has been occurred.
A Disaster recovery plan should contain all these above three categories of recovery of disaster to be an efficient recovery plan. (Gorman, 2014)
Strategies used in Disaster recovery planning
Different business objectives need different strategies for the data recovery plan. These strategies are the basics on which the budget of the organisation for information technology is set. Setting up a protection plan includes a cost and time so an organisation should undergo an analysis of cost benefit so that they can be able to determine that which method will be the best one in terms of effectiveness and proving the cost benefit. (Gorman, 2014) So some of the strategies available for Disaster recovery are:
- Continuous or frequent backup of the data on a magnetic tape.
- Back up of data on disks, automatically
- Making a replica of data on a private cloud.
- UPS can be used or the generator of backup so that the backup system can work even if there is no power.
- Fire protection strategies can be implemented
- Security software like firewall, a viruses, etc can be used and implemented.(Mullins C. S., 2016)
Importance of Integration of Database Backup and Disaster Planning
The disaster is recovered when the database is recovered. If any destruction takes place then the database backup plans save the data which is significant and this is the main objective of database backup. And on the other side, the data recovery strategies aim at saving the data and the physical storage devices of the organisation. The database back and the disaster recovery work hand in hand with each other as they cannot be implemented properly without the support of each other. (Mullins C. S., 2012) The integration of these will help the management of database in many ways as database helps in recognising and deciding that which data is to be stored and backed up and the disaster planning helps in choosing a perfect data recovery plan for the storage and protection of important data. (Bartkowski, Buitlear, & Kalicki, 2012). For e.g. The data backup plan will determine that the backup should be consistent or inconsistent and the disaster planning will determine that where the data storage can be one and what solutions should be used. The analysis of cost benefit will also be done. So, if the whole situation will be analysed then it can be seen that the organisation should have complete set of package which includes the methods and strategies for keeping the data safe and backup should be maintained. (Gorman, 2014)
It can be concluded that the organisation should adopt the data backup methods and plans for the recovery of data should be made appropriately so that the organisation can recover any disaster occurrence on time and effectively. The data protection is very essential for the organisation because it makes smooth functioning of the business and it also saves the cost, time and efforts of the organisation. It can be concluded that it is important to adopt the integration of data backup and disaster planning as they both work hand in hand and function effectively.
Bartkowski, S., Buitlear, C., & Kalicki, A. (2012). High Availability and Disaster Recovery Options for DB2 for Linux, UNIX, and Windows. IBM Redbooks.
Gorman, M. M. (2014). Database Management Systems. . Butterworth-Heinemann.
microsoft. (2008). Planning for Disaster Recovery. Retrieved 01 31, 2016, from https://technet.microsoft.com/en-us/library/ms178094(v=sql.105).aspx
Mullins, C. S. (2012). Database Administration. Addison-Wesley.
Mullins, C. S. (2016). Database Performance Managemment. Retrieved 02 01, 2016, from http://www.craigsmullins.com/dbta_003.htm
Phillips, B. D. (2011). Disaster Recovery. CRC Press.
techopedia. (2016). Database Backup. Retrieved 01 31, 2016, from https://www.techopedia.com/definition/29388/database-backup