theuntitled/query.sql

Created July 7, 2016 11:15

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/theuntitled/214b88058673c9f80c5a14ca784f66e7.js"></script>
Save theuntitled/214b88058673c9f80c5a14ca784f66e7 to your computer and use it in GitHub Desktop.

Download ZIP

Get all logical database file names

Raw

	SELECT DB_NAME(database_id) AS DatabaseName, name AS LogicalFileName, physical_name AS PhysicalFileName
	FROM sys.master_files AS mf

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment