sqlserver 清理日志

?

ALTER? proc [dbo].[del_baklog]
as
----备份数据库
declare @num tinyint
declare @date nvarchar(100)
declare @name nvarchar(100)
declare @db_name nvarchar(100)
declare @i int? -- =1
set @i=1
select @num=MAX(database_id)?? from sys.databases
while @i<=@num
begin
set @db_name=db_name(@i)
if (@db_name? in ('NewDBFAQ','RainBow_common'))? begin
set @date='D:baklog'+@db_name+'_log_'+rtrim(replace(convert(char,getdate(),111),'/',''))+rtrim(replace(convert(char,114),':',''))+'.log'
set? @name=@db_name+'_log_'+rtrim(replace(convert(char,''))
BACKUP log @db_name TO? DISK =@date WITH NOFORMAT,NOINIT,NAME = @name,SKIP,REWIND,NOUNLOAD,? STATS = 10
end
set @i=@i+1
end

-----删除备份文件declare @del_date varchar(100)set @del_date=left(convert(nvarchar,dateadd(DD,-2,getdate()),120),10)+'T'+convert(nvarchar,dateadd(HH,108)EXECUTE master.dbo.xp_delete_file 0,N'D:baklog',N'log',@del_date

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!