SQLserver 脚本备份

增量（以日期格式生成文件名.bak）
BACKUP DATABASE ceshi TO  
DISK = N'd:\ceshi\backup\ceshi_INCREMENT_.bak' 
WITH  DIFFERENTIAL , NOFORMAT, NOINIT,  
NAME = N'zengliang-Differential Database Backup', 
SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
-------------------------------------------------------------------
完整（以日期格式生成文件名.bak）
use master  
go  
declare @Database nvarchar(256),@Path nvarchar(2048)  
select @Database=N'ceshi',@Path=N'D:/ceshi/backup/'  （这里是数据库和，备份地址）
declare @sql nvarchar(max)  
select @sql =N'BACKUP DATABASE '+@Database+N'     
    TO  DISK = '''+@Path+@Database+N'_FULL_BACKUP_'+REPLACE(REPLACE(REPLACE(convert(nvarchar(30),getdate(),112),'-','_'),':','_'),'.','_')+N'.bak''  
WITH   
    NOFORMAT,   
    INIT,    
    NAME = N''FULL Database Backup'',  
    SKIP'  
exec (@sql)  
go
-----------------------------------------------------------------
二次修改增量备份（以日期格式生成文件名.bak）
declare @name varchar(250) 


set @name='d:\ceshi\backup\ceshi_INCREMENT_BACKUP_'+ convert(varchar(50),getdate(),112)+'.bak' 


BACKUP DATABASE [ceshi] 
TO  
DISK = @name 


WITH 
DIFFERENTIAL,
NOFORMAT,
NOINIT,  


NAME = N'zengliang-Differential Database Backup', 


SKIP,
NOREWIND,
NOUNLOAD,
STATS = 10


GO
-----------------------------------------------------------------