I have a simple full backup job on my SQL 2012 Server that overwrites after every job as seen below.
I need to modify it so that it overwrites only once a week.
I would either use retain days = 3 or expiredate somewhere but not sure if that will fit my stated goals for a rolling backup method?
Backup database Orion
To disk = 'd:\Orion.bak'
With init, format;