I have a backup that runs every evening. I set the backup to expire in 7 days time and have it appended to an existing backup set.
When I look at the contents of the backup set I can still see backups which have expired and show the expired date in the past.
e.g. It is 23/11/2007 today and I view my backup set and can still see backups showing an expiry date of 22/11/2007.
I need to remove the expired backups from the set as I do not want the backup set file growing too large in size and therefore a pain to transfer off of the server to another location.
I tried to find somewhere I can remove expired backups from within Microsoft SQL Server Management Studio Express but am unable to locate anywhere to do this. I know you can view the contents of a backup set by selecting the database ...
Go to the complete details ...