snyderkv
asked on
SQL T-SQL Backups
EE,
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;
Thanks again
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;
Thanks again
why not set the job itself to only run once a week ?
ASKER
So we can have a revolving backups
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Created two backup jobs but realized I can also do a maintenance cleanup task to delete old files as T-SQL doesn't have that functionality