set showplan_all {on | off}
set showplan_text { on | off }
set statistics profile { on | off }
9、 差异备份：
declare @str varchar(100)
set @str=’D:’+replace(replace(replace(convert(varchar,getdate(),20),’-‘,”),’ ‘,”),’:’,”)+’.diff’
BACKUP DATABASE smallerp TO DISK=@str
WITH DIFFERENTIAL,RETAINDAYS=8,NOFORMAT,NOINIT,
NAME=N’Demo差异备份’,SKIP,NOREWIND,
NOUNLOAD,STATS=10
GO
10、 删除过期的备份文件，并设定每天两次：
declare @str varchar(100),@dir varchar(100),@fileName varchar(30)
set @dir=’del D: ‘
set @filename=left(replace(replace(replace(convert(varchar,getdate()-15,20),’-‘,”),’ ‘,”),’:’,”),8)
set @str=@dir+’fullbak’+@filename+’*.bak’
exec xp_cmdshell @str
set @filename=left(replace(replace(replace(convert(varchar,getdate()-8,20),’-‘,”),’ ‘,”),’:’,”),8)
set @str=@dir+’diffbak’+@filename+’*.diff’
exec xp_cmdshell @str
set @filename=left(replace(replace(replace(convert(varchar,getdate()-8,20),’-‘,”),’ ‘,”),’:’,”),8)
set @str=@dir+’logbak’+@filename+’*.trn’
exec xp_cmdshell @str
先这些吧，貌似一般不用又相对比较常用~
