Installing on C

fruyven

Hello,

During install (of the trial version) we indicated that the location of the files should be \Program Files\Red Gate\SQL Monitor 2\.

So far so good.

But still on C:\Documents and Settings\All Users\Application Data\Red Gate 3 folders exist, including 1 with the logs. Now my admin is not amused.

Is it possible to override this location?

Brian Donahue

The logging for SQL Monitor is done through a third-party component called Log4Net, so the log location can be configured. If you open c:\program files\red gate\sql monitor 2\BaseMonitor\RedGate.Response.Engine.Alerting.Base.Service.exe.logging.config.

The default puts the logs in %allusersprofile%\application data, but you can hard-code the folder as well.

<file type="log4net.Util.PatternString">
        <converter>
          <name value="folder" />
          <type value="RedGate.Response.Common.Utilities.Logging.CommonApplicationDataFolderPatternConverter, RedGate.Response.Engine.Alerting.Base.Service" />
        </converter>
        <conversionPattern value="%folder\Red Gate\Logs\SQL Monitor 2\Base Deployment" />
      </file>

You should be able to remove the reference to the commonapplicationdatafolderpattern and hard-code the folder:

<file type="log4net.Util.PatternString">
        <conversionPattern value="d:\Log Files\Red Gate\SQL Monitor 2\Base Deployment" />
      </file>