sql提供了哪几种备份策略

发布网友 发布时间：2022-04-24 11:00

我来回答

共1个回答

热心网友 时间：2022-05-03 07:01

全量数据备份
Sql语句：BACKUP DATABASE [wxh] TO  DISK = N'C:\Program Files\Microsoft SQL
Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\wxh.bak' WITH NOFORMAT,
NOINIT,  NAME = N'wxh-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, 
STATS = 10

增量数据备份(Differential Backups)
Sql语句：BACKUP DATABASE [wxh] TO  DISK = N'C:\Program Files\Microsoft SQL
Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\wxh.bak' WITH  DIFFERENTIAL ,
NOFORMAT, NOINIT,  NAME = N'wxh-Differential Database Backup', SKIP,
NOREWIND, NOUNLOAD,  STATS = 10

日志备份
Sql语句：BACKUP LOG [wxh] TO  DISK = N'C:\Program Files\Microsoft SQL
Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\wxh.bak' WITH NOFORMAT,
NOINIT,  NAME = N'wxh-Transaction Log  Backup', SKIP, NOREWIND,
NOUNLOAD,  STATS = 0

增量数据备份与日志备份相结合