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 DBA require to find all different locations of database backup files.
In our organization, I have 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 also require to remove old backup files.
I am fetching this location details from MSDB database.
SELECT Distinct physical_device_name
Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.
If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.
I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.