SQL Server: Script to find the Location of Database Backup Files

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.

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz