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.
1 2 3 |
SELECT DBS.name as [Database], DBM.name as [File Name], DBM.physical_name as [File Location] from sys.databases DBS inner join sys.master_files DBM ON DBS.database_id = DBM.database_id WHERE DBS.database_id>4 |
What is blocking Blocking is an unavoidable and by-design characteristic of any relational database management system (RDBMS) with lock-based concurrency….
Scenario As a DBA often we face a scenario that someone has dropped the database and we need to find…