数据库: IBM DB2, Microsoft SQL Server和Oracle的增量备份

The incremental backup of DB2, SQL Server and Oracke database. No matter what sort of incremental backup, the relevant full backup is required in advanced.

Microsoft SQL Server:

BACKUP DATABASE { database_name | @database_name_var }   TO 
  
  
   
    [ ,...n ]     [ WITH DIFFERENTIAL ]
[;]
  
  

http://msdn.microsoft.com/en-US/library/ms175526%28v=SQL.90%29.aspx

IBM DB2:

1) Enabling incremental backup:

DB2 UPDATE DATABASE CONFIGURATION FOR database-alias USING TRACKMOD YES

After you set TRACKMOD to YES, you must back up the database before allowing applications to change data. In other words, you must take a full database backup so that you have a baseline against which in