Link to home
Start Free TrialLog in
Avatar of dastaub
dastaubFlag for United States of America

asked on

SQL 2005 backup Maintenance Plans

a backup maintenance plan was created.  "Backup set will expire" was set to 2 days.  I assumed that meant SQL would delete the old backup files due to their expiring?  This is not occurring.  What is the process to get the old backups deleted?  I do not wish to have dozens of full backups.  I only want to have 2 sets of full backups.
Avatar of dastaub
dastaub
Flag of United States of America image

ASKER

I did notice the file names SQL gives the full backups and transaction log backups are given unique names by adding the date and time to the name of the backup file name.
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial