Database Recovery Techniques in DBMS
Database Recovery Techniques in DBMS Database Failure: In every computer database management system, there is a possibility of computer hardware or computer software failure. The failures may occur without warning. The data in the database may be lost or damaged due to the failures of DBMS. After a failure occurs, a DBMS should recover the information that was entered into the database. Reasons for Database Failure: The most common failures are as follows: Failure of a computer system Break down of hardware. Program bugs User mistakes Types of Failures: Generally, there are two types of failure: System Failure A computer system failure is also said to be an instance of failure. It is a failure of the main memory of a computer system. Computer system failures may be caused by a power failure of a database, an application or operating system crash, memory error, or some other reason. The end result is the unexpected termination of the database management system software. Media Failure