SqlServer 完整，差异备份

--完整备份

USE Master
GO
declare @backuppath nvarchar(100)
set @backuppath='F:\MyDB_'+convert(nvarchar(10),getdate(),112)+'_full.bak'
BACKUP DATABASE MyDB TO DISK=@backuppath
WITH RETAINDAYS=15,NOFORMAT,NOINIT,
NAME=N'MyDB 完整备份',SKIP,NOREWIND,
NOUNLOAD,STATS=10
GO

--差异备份

USE Master
GO
declare @backuppath nvarchar(100)
set @backuppath='F:\MyDB_'+convert(nvarchar(10),getdate(),112)+'_diff.bak'
BACKUP DATABASE MyDB TO DISK=@backuppath
WITH DIFFERENTIAL,RETAINDAYS=8,NOFORMAT,NOINIT,
NAME=N'MyDB 差异备份',SKIP,NOREWIND,
NOUNLOAD,STATS=10
GO