Clients that are backing up Database files in a policy

[Codedtech]

Hey Guys,

As part of an initiative, I've been tasked to rummage through my 100+ master servers and locate all the clients that are running DB backups through normal file policies. I'm not really sure where to begin, do you guys have any ideas?

[quebek]

I would have collected DB servers names along with DB install folder and its data folder - this informaiton should be coming from your DBA. Than having this I would have checked the exclude policy for these DB servers and added there the data folder - to exclude this data from backup - as it is most probably useless.

[Nicolai]

So you mean finding database files not excluded from the file system backup ?

Are you running Windows or Linux ?

In that case I would use bplist and search for known database files .e.g .dbf or .ndf .ldf. You will need some sort of script to automate the process. Look for the incremental backup with the highest number of gigabyte in backup size, those incremental backups usually have database files included.

Hint - Findstr or grep won't work correct with the null byte 

Remove null byte from bplist output

http://www.mass.dk/netbackup-quick-hints/remove-null-byte-from-bplist-output/