Can anyone please send me the script to delete the old backup files greater than 2 days from the disk automatically? I am using SQL Server 2000.
A:
This is very easy if you create a maintenance plan to perform your backup.
One of the options is "remove files older than". Here you can specify to delete the backups older than two days.
Andy Jones
2009-03-20 09:21:09