1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
|
declare @db_name varchar(255)
declare @backup_dir varchar(255)
declare @cmd varchar(255)
declare @extension varchar(5)
declare @serverName varchar(255)
declare @strSql varchar(8000)
set @serverName = 'SQLBRU01'
set @db_name = 'ERSS'
set @backup_dir = 'I:\Backup\'
set @extension = 'BAK'
--Clean
--delete 7 day old
set @cmd = 'del '+ @backup_dir + @db_name + '_db_' + Convert(varchar,getdate()-7,112) + '*.' + @extension
print @cmd
exec master..xp_cmdshell @cmd
--delete 8 day old
set @cmd = 'del '+ @backup_dir + @db_name + '_db_' + Convert(varchar,getdate()-8,112) + '*.' + @extension
print @cmd
exec master..xp_cmdshell @cmd
--delete 9 day old
set @cmd = 'del '+ @backup_dir + @db_name + '_db_' + Convert(varchar,getdate()-9,112) + '*.' + @extension
print @cmd
exec master..xp_cmdshell @cmd
--delete 10 day old
set @cmd = 'del '+ @backup_dir + @db_name + '_db_' + Convert(varchar,getdate()-10,112) + '*.' + @extension
print @cmd
exec master..xp_cmdshell @cmd
--delete 11 day old
set @cmd = 'del '+ @backup_dir + @db_name + '_db_' + Convert(varchar,getdate()-11,112) + '*.' + @extension
print @cmd
exec master..xp_cmdshell @cmd
--delete 12 day old
set @cmd = 'del '+ @backup_dir + @db_name + '_db_' + Convert(varchar,getdate()-12,112) + '*.' + @extension
print @cmd
exec master..xp_cmdshell @cmd
--delete 13 day old
set @cmd = 'del '+ @backup_dir + @db_name + '_db_' + Convert(varchar,getdate()-13,112) + '*.' + @extension
print @cmd
exec master..xp_cmdshell @cmd
--delete 14 day old
set @cmd = 'del '+ @backup_dir + @db_name + '_db_' + Convert(varchar,getdate()-14,112) + '*.' + @extension
print @cmd
exec master..xp_cmdshell @cmd |
Partager