April 23, 2012 at 6:24 am
Hi,
When I put the backup expires after one week, what does it mean, i.e. does it mean that SQL server will automatically delete those files after a week ? This is when I am not adding my backup to a single file.
April 23, 2012 at 7:46 am
Yes, it will delete it. If you moved that file, it would still be a valid file. The backups don't "expire," the clean-up will simply delete them.
Jared
CE - Microsoft
April 23, 2012 at 7:59 am
Backups can be set to expire - this is when the backup set can be overwritten with a new one. The maintenance cleanup task is different - it deletes the whole file.
John
April 23, 2012 at 8:06 am
John Mitchell-245523 (4/23/2012)
Backups can be set to expire - this is when the backup set can be overwritten with a new one. The maintenance cleanup task is different - it deletes the whole file.John
Doh! My bad. I misunderstood where the OP was looking.
Jared
CE - Microsoft
April 24, 2012 at 4:00 am
Backup set expire window specifies when the backup set can be overwritten by another backup set.
It does not delete the physical backup file.
To remove the physical backup file, you have to add another task 'maintainance cleanup task'.
April 24, 2012 at 4:04 am
Thats bang on, I was looking for. I have a backup job under maintenance plan but it doesnt delete the files after a week and I am having files getting accumulated and had to delete it manually.
Thanks a lot viduvs
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply