各种数据库的备份与恢复（Backup and recovery of various databases）.doc

各种数据库的备份与恢复（Backup and recovery of various databases） Introduction to database backup and recovery This is a comprehensive description of the database backup article, it is necessary to make all the database backup and recovery of all clear description, not my original intention of this article. I just want to give those who want to make backups. But not how to understand the backup person, a whole understanding. My level is limited. I can only throw a brick. A lot of experience and personal statements of a school. Please correct the error. (email address tanfufa@) One: the importance of database backup The hardware will always be bad, the system will crash, the data files will always be corrupted, and no one can ever make mistakes. The database backup is broken on your hard drive. The system crash is broken. The data file is corrupted and the staff mistakenly deleted the data so that you are not sad and not afraid. The database backup is different from the general file backup. A backup scheme always has something to do with the customers needs, a query database that never adds new data. A cold backup is enough. And for a 7X24 hour database. System that data cannot be lost. The backup scheme is much more complex. How can you ensure that the database does not lose data? This will be subject to two conditions. A: database types. Two: backup method. Two: database backup and recovery categories 2.1 logical backup and recovery Logical backup is the use of software technology to extract data from the database and write the results to an output file, a logical backup, because flexibility is favored by developers. But for a database administrator. Just dont worry about it. A: he is the logic of points. He can only describe the logical structure of the database at one point. These logical objects are then extracted and written to one or more output files. In general, a full backup is a continuous occurrence of one point and another point (termination point). Logical backups