Physical file location for all the databases in SQL Server

Introduction

Very often DBAs need to find the location of the physical file (MDF, LDF & NDF) of a database. Simply we can obtain the output by executing the below query. Run the script to get the SQL Server database file location for all the databases for a particular instance.

Script to find the physical file location

Result

Physical File Location


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *