Close

Monthly Archives: January 2014

List database file locations

Below query will list the database file locations on a sql server instance. USE master GO SELECT  name AS [Logical Name],  physical_name AS [DB File Path],  type_desc AS [File Type],  state_desc AS [State] FROM  sys.master_files GO  

Read More