Browse by Tags

• data file
• location
• log file
• program files
• tsql

TSQL to get default location of database data and log files?
08 January 08 05:37 AM | SQL Master | 2 Comments   

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 Read More...

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