Comprehensive data protection for all workloads
Post Reply
nunciate
Expert
Posts: 247
Liked: 39 times
Joined: May 21, 2013 9:08 pm
Full Name: Alan Wells
Contact:

Comparing Backup Flat files to what is in the database

Post by nunciate »

I replaced some underlying storage for my Scale-Out Repository over the last couple of weeks and noticed something odd.
I put the old repository in maintenance mode. I then performed an "Evacuate Backups" on that repository. After the evacuation completed I did a quick file search of that drive for *.* in Windows Explorer.
If found quite a few backup files left on the drive. They all appeared to be backups older than 30 days which is how long we keep onsite backups.
I went ahead and manually deleted them and that hasn't caused me any troubles but it makes me wonder why those were left behind when they should have been removed under my retention settings.

Is there a script that can look at my database, compile a list of files and file locations and then perform a compare of the actual file system to see if there are extra files? I'd like to keep my file system as clean as possible to save disk space.

Even if someone can give me a SQL script to pull that list out of the DB I should be able to find a way to do a check on the file system myself using that data.
PTide
Product Manager
Posts: 6408
Liked: 724 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Comparing Backup Flat files to what is in the database

Post by PTide »

Hi,
If found quite a few backup files left on the drive. They all appeared to be backups older than 30 days which is how long we keep onsite backups.
This does not seem right - I recommend contacting our support team for investigation. Please post your case ID once you do.

Thanks
Post Reply

Who is online

Users browsing this forum: ante_704, Google [Bot] and 200 guests