I'm (trying) managing a large number of sql server instances among a number of machinces running SQL Server 2005 and 2008. Almost all the DB are in Simple Recovery Model. I'm doing full backups every Sunday and differencial backups every day. Even though I am using compressed backups, there are databases which are nearly a TB. Therefore, I need to have a proper use of the backups regarding the space they are allocating.
My goal: I just need to have one full and one differencial backup for each database every single moment.
My question : What actions should I perform in order to achieve my goal? I guess something i need to do with the expiration of the backups and the "Clean up history", but I am not sure what exactly i need to do.