I have a server running Windows Server 2008 SP2, and SQL Server 2005 Express.
There is a daily backup which runs via the Windows Task Scheduler. It keeps the last 7 days of backups and deletes the earlier ones automatically.
How/where do I change the number of days of backups that it keeps ?
UPDATE: As per comments to the question, here is the contents of the script that is running:
exec expressmaint @database = 'xxxx', @optype = 'DB', @backupfldr = 'c:\sql_data\backup', @reportfldr = 'c:\sql_data\backup\reports', @verify = 1, @dbretainunit = 'weeks', @dbretainval = 1, @rptretainunit = 'weeks', @rptretainval = 1, @report = 1 go
I would now like to store 4 days of backups instead of 7