Installing on C

fruyven · August 23, 2011 6:54AM

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 · August 23, 2011 8:51AM

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.

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

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

&lt;file type="log4net.Util.PatternString"&gt;
        &lt;conversionPattern value="d:\Log Files\Red Gate\SQL Monitor 2\Base Deployment" /&gt;
      &lt;/file&gt;

Installing on C

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk