SQL Server Backups
Posted on 2011-10-18
I have been called about a SQL Server whose disk space is being eaten at roughly 6GB/day from SQL Server backups. They go back about 80 days. I would assume them to be full backups, as they are each around 800MB and getting steadily a little larger every day, so 80 days worth would not be necessary. However, I need to know:
How do I view backup settings in SQL Server 2005?
Is there a way to tell it to use only so much space or only keep so many days' worth of backups?
Any other suggestions I don't know to ask?