By default, foglight installation process would create the data file and log file for foglight repository to the same folder as master's, see sqlsvr_create_db.sql
USE master;
DECLARE @data_path nvarchar(256)
SET @data_path = (SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1)
FROM master.sys.master_files
WHERE database_id = 1 AND file_id = 1)
If customer changes the Database default locations, and keep the master files in the old folder, foglight would still create the data and log files to the old folder. We may consider to improve this.
Here using below parameters can get the Database default locations for data file and log file.
SELECT SERVERPROPERTY('InstanceDefaultDataPath') AS InstanceDefaultDataPath, SERVERPROPERTY('InstanceDefaultLogPath') AS InstanceDefaultLogPath
Looks like MS added that 2 parameters from sqlserver 2012, that can explain.
STATUS: FGL-19965 has been submitted for fix in a future post 5.9.4 release.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center