Browse by Tags

TSQL to get default location of database data and log files?

Published 8 January 8 6:37 AM | SSQA.net

By default the SQL Server database data & log files are created on the default data directory which is Program Files or based on where SQL binary files are installed. In order to find what is the default location you can run following TSQL: declare...

Filed under: sql server, databases, location, tsql, data file, log file, default, program files

TSQL to compare log file to data file in a database

Published 1 August 7 4:7 AM | SSQA.net

SELECT @@servername as ServerName , db_name ( database_id ) as DatabaseName , Name as LogiCalFileName , Physical_Name [Physical file] , ( size * 8 )/ 1024 [Size_MB] FROM sys.master_files...( read more ) Read More...

Filed under: tsql, data file, log file