As this is the section of DBA script, so I am sharing one more SQL Server DBA Script to find the location of database backup files.
This script is very useful to the Database Administrator because sometimes DBAs are finding all different locations of database backup files.
In our organization, I found that many of database developer and junior database administrator are taking backup in a different location so I always wonder about to find a different location of the Database Backup file because we should also remove old backup files.
I am fetching this location details from MSDB database.
SELECT Distinct physical_device_name