sqlserver 差异备份

use master  
 go  
 declare @Database nvarchar(256),@Path nvarchar(2048)  
 select @Database=N'AdventureWorks',@Path=N'D:/TDDOWNLOAD/'  
 declare @sql nvarchar(max)  
 select @sql =N'BACKUP DATABASE '+@Database+N'  
     TO  DISK = '''+@Path+@Database+N'_DIFF_'+REPLACE(REPLACE(REPLACE(convert(nvarchar(30),getdate(),126),'-','_'),':','_'),'.','_')+N'.bak''  
 WITH   
	DIFFERENTIAL'  
exec (@sql)

差异备份之前,必须要就一个基准备份,也就是完整备份

参考:http://blog.csdn.net/ylqmf/archive/2010/07/08/5721220.aspx