November 10, 2010 at 12:39 am
I have 3 backup devices that i use for backing up all databases.
Full device (full backup for all databases running weekly)
Diff device (diff backups for all databases running daily)
Log device (log backups for all databases running hourly)
I want to purge old backups from these backup devices.
How can i accomplish this ?
November 10, 2010 at 12:45 am
add a cleanup task and define your retention period.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 10, 2010 at 1:30 am
you can perform backup WITH INIT clause,
CAUTION: This will remove all the backups from the media set, which has expired or retain period is over,
You can set the Retain Days while performing the backup.
Vishal Gajjar
http://SqlAndMe.com
November 11, 2010 at 2:31 am
Hi,
Abow both answers are correct also you will schedule that older 25 day's data delete........
Regards
Satish
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply