Tag Archives: sys.master_Files

T-SQL to check Data and Log Files are on same drive or not

The below query help us in finding the physical existence of data and log files are on same drive or not of all the database in a SQL Instance. ;WITH LogCTE AS  (  SELECT DISTINCT LD.Database_Name  FROM  (  SELECT DB_NAME(database_id) AS [Database_Name], LEFT(Physical_Name, 1) AS [Drive_Letter] FROM sys.master_files WHERE type_desc = ‘LOG’ AND database_id > 4  ) AS LD   INNER JOIN    sys.master_files mf     ON LD.Drive_Letter = LEFT(mf.physical_name, 1) and mf.name=LD.Database_Name  WHERE  … Continue reading

Posted in T-SQL, Uncategorized | Tagged , , | Leave a comment