Monday 30 May 2011

delete old bak files

EXEC xp_cmdshell 'FORFILES /p "H:\Microsoft SQL Server\MSSQL.2\MSSQL\Backup" /s /m *.* /d -2 /c "CMD /C del /Q /F @FILE"'


d -2 we have to give no of days

No comments:

Post a Comment