SQL 2012 backup job

Hi all,

Im not a DBA but I have to backup all out databases. I have setup a maintenance job that takes a full backup of our databases every night. I have ticked the box that says "backup set will expire" after 7 days, but it keeps filling up the disk. Am I missing something?
BUbackup2.JPG
MattAsked:
Who is Participating?
 
Carl TawnConnect With a Mentor Systems and Integration DeveloperCommented:
The "Backup set will expire" option only indicates after how long a backup set can be overwritten, it doesn't actually remove the old backups from disk.

You will need to add a separate "Maintenance Cleanup Task" to do that: http://msdn.microsoft.com/en-us/library/ms177182.aspx
0
All Courses

From novice to tech pro — start learning today.