执行 FULL 和 DIFFERENTIAL 备份

命令

-- Full backup:
BACKUP DATABASE [Customer]
TO DISK = N'D:\Backup\Customer_full_20260706.bak'
WITH COMPRESSION, CHECKSUM, INIT, STATS = 10;

-- Differential backup:
BACKUP DATABASE [Customer]
TO DISK = N'D:\Backup\Customer_diff_20260706.bak'
WITH DIFFERENTIAL, COMPRESSION, CHECKSUM, INIT, STATS = 10;

作用

FULL 备份整个数据库；DIFFERENTIAL 备份自上次 FULL 以来更改过的区。

适用场景

FULL：每日/每周的基础备份。DIFF：FULL 之间的快速中间备份。

注意

还原 DIFF 需要其基础 FULL 备份。INIT 会覆盖现有文件；文件名写错会丢失一份备份。CHECKSUM 能及早发现损坏。