my goal is simple. i want to have SQL keep a nightly backup of a DB for a rolling 5 days.
so each night at some time i want a new DB backup made and one deleted such that i have a rolling 5 days on disk.
i am trying to get a maintenance plan set up to handle this work and have the saving of the file done (i think). i have the backups being appended so a single bak file will contain the rolling 5 days (not sure this will work 0 cause how will SQL know what to delete, and deleting the single bak file will remove all the backups).
as you can tell i am having problems figuring out how to remove older backups fo the DB so that i have only the most recent 5 on disk.
any tips for me on this?