I have a SQL 2016 database server. With a D: drive for SQL data and E: for logs.
Somehow when using default database location it puts the databases on the original default path : C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA.
When I use a fixed path it put both SQL data and log file there.
How would i go about fixing this?
You can set the custom db path in the provider settings. Currently you are unable to separate the database from the logs.
As far as making fix’s yourself you can signup to be a contributor at https://solidcp.com/contributors/become-a-contributor/ which gives you access to the source code and submit fix’s you have implemented.
From what I can tell the default database location is being selected as path where the master DB resides.
Or whatever you override it with.
SQL stores the default data and log path’s in the registry. If somehow you could use those as default that would be great.
HKEY\Software\Microsoft\Microsoft SQL Server\#sql version#\MSSQLServer\