oracle与sql server在数据备份与恢复上的差异（Differences between Oracle and SQL Server in data backup and recovery）.docVIP

oracle与sql server在数据备份与恢复上的差异（Differences between Oracle and SQL Server in data backup and recovery） Before explaining the specific differences in both, I want to talk about a few concepts associated with the backup. To understand these concepts, to understand the differences of the two database in the data backup, is of great significance. The first is the concept of full database backup. All the backup data in the database, regardless of whether the database update. In other words, no matter whether there have been recent updated database, database backup program will backup the data content and the data; attribute update has been backed up. Generally speaking, in the actual work, change the basic structure of the database or the data after the update, regardless of whether there are other backup strategy, all the best for a full backup of the database. The second concept is the backup database. A backup on a full backup after changing data. A differential backup is based on full backup; backup all files on a full backup after the change. As our backup strategy is to do a full backup Saturday, a differential backup the other day. Is next Monday will last Saturday after the backup database of all data changes; data content and difference next Friday will all change backup backup backup completely since the last Saturday. The starting point is always the last full backup backup time. Third is the concept of incremental backup database. The incremental backup is a backup backup (including full backup, differential backup, incremental backup) all the data after the change. Incremental backup is a pointer to a backup for any. As we now backup strategy is Saturday for a full backup, the other day for an incremental backup. Wednesday is the last backup backup, which is Tuesday after the backup change data. All the data and not from Saturday full backup occurred after update. So, the difference of data backup and data backup or both have relatively large difference. One o