Thursday, April 22, 2010

Database backup and restore principles

Databases are the technical basis of the most data repositories in the world today! Downtime in transaction of processing systems is crucial to all organizations with a high possibility of operations can shutdown. Database management system (DBMS) must recover errors without data loss, and preferably in a short time. Therefore the State database must be restored it in, was shortly before a problem stopped all database processing.

Database backups often occur; however, always provisional data missing you, to update the database between backup jobs intervals!As shown in the illustration below, a completed transaction on the active database and a transaction journal has copied installation.If a database backup is performed the transaction list is marked with a date stamp to point out if recovery is required.



View the Original article

No comments:

Post a Comment