SQL Server 2008 R2 (64 bit) running on Windows Server 2008 R2.
I have a Maintenance Plan that I created with the wizard. It simply does a Full backup each night. I have the "Backup set will expire" set to "After 1 days". Everything else is the default (disk folder and bak extension). The backup files are not automatically deleting each night.
This worked fine in Win 2003/SQL 2000 so I'm guessing it is some crazy "over the top" security measures that have been added to Windows/SQL 2008. (Wish I could turn it off as I'm not concerned with security - only myself and my coworker get on this server.)
I have added the "SQLServerSQLAgentUser$username
MSSQLSERVER" Group to the 'Backup' folder and it has full permissions.
I'm not a security expert or Pro DBA (main job is developer) so I guess I'm going to need some step-by-step advice to fix this.