2010. 9. 13. 15:59
Brain Trainning/DataBase
대략... Job로그 등의 삭제와
필요없는 과거 DB Backup File의 삭제
declare @DeleteDate nvarchar(50)
declare @DeleteDateTime datetime
set @DeleteDateTime = DateAdd(dd, -10, GetDate())
set @DeleteDate =
(Select Replace(Convert(nvarchar,
@DeleteDateTime, 111),
'/', '-') + 'T' + Convert(nvarchar, @DeleteDateTime,
108))
EXECUTE master.dbo.xp_delete_file 0,N'E:\DeleteTest',N'bak',@DeleteDate,1
/*
CleanUp Task
*/
declare @dt datetime
set @dt = dateadd(m,-7,getdate())
EXEC msdb.dbo.sp_delete_backuphistory
@oldest_date=@dt
EXEC msdb.dbo.sp_purge_jobhistory
@oldest_date=@dt
EXEC msdb.dbo.sp_maintplan_delete_log @oldest_time=@dt
EXEC msdb.dbo.sysmail_delete_mailitems_sp @sent_before=@dt
'Brain Trainning > DataBase' 카테고리의 다른 글
MySQL Clustering on Ubuntu (0) | 2010.09.29 |
---|---|
MySQL Cluster 구성 (0) | 2010.09.20 |
Brad M. McGehee SQL Presentations (0) | 2010.09.08 |
유용한 SQL Poster (0) | 2010.08.26 |
MSSQL Job(작업) 결과 조회 쿼리 (0) | 2010.08.25 |