Changing Default Database File Locations in SQL Server 2016
At some point in your career as a data professional you will need to change the default database file locations in SQL Server 2016.
At some point in your career as a data professional you will need to change the default database file locations in SQL Server 2016.
When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties.