--完整备份
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