Log files collect information about SQL Source Control while you use it. These files are useful if you're working with Redgate support to fix a problem.

By default, the log level of SQL Source Control is set to Warning (see the table below). This can produce large log files. If you're troubleshooting a specific problem, you may want to change the amount of logging.

Changing the log level

• Close SQL Server Management Studio.
• Go to the SQL Source Control config files folder. By default, this is %localappdata%\Red Gate\SQL Source Control 7

• Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.

• Inside the <EngineOptions> tags, add:

  <LogLevel>your specified log level</LogLevel>

  You can specify:

  Log level	Effect
  None	Disables all logging.
  Debug	Logs additional debug information.
  Trace	Logs stack trace after an exception.
  Information	Logs information collected when getting changes in the Get latest tab.
  Warning	(Default) Logs information collected when minor errors occur.
  Error	Logs information collected when mid-level errors occur.
  Fatal	Logs information collected when fatal errors (ie crashes) occur.
  Serious	Combines the warning, error and fatal log levels (ie logs information from all error types).
  Default	Combines the debug, trace, information and serious log levels.
  All	Logs all messages.

E.g.

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!---->
<EngineOptions version="3" type="EngineOptions">
  <LogLevel>All</LogLevel>
</EngineOptions>

• Save and close the file.

SQL Source Control saves log files with the setting you specified.

Locating the log files

By default, log files for all Redgate tools are located in: %LOCALAPPDATA%\Red Gate\Logs