Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal
< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7
You are here: Welcome to Toad > About Settings Files

About Settings Files

Toad settings are located in the Application Data Directory (click the Application Data Directory link in Help | About to open the directory) and store personal layouts, customizations, log files, and other information. See Toad for SQL Server Installation Guide for more information on upgrading and migrating settings.

To view settings

  1. Select Help | About from the menu.

  2. Click the Application Data Directory link to open the folder that contains the following:

    File

    Description

    Action.log

    Tracks your usage within Toad. If you agree to share this data, the file is automatically sent to Quest on a periodic basis.

    Connections.xml

    Contains all connections stored in the Connection Manager or the New Connection window.

    ConnectionTrace.log

    Contains the SQL Output connection trace log file if you select Tools | Execution Trace from the menu.

    ExceptionTrace.log

    Contains a log of all exceptions encountered while running Toad.

    FTPConnection.log

    Contains a log of exceptions encountered when attempting to connect to FTP servers.

    FTPConnections.xml

    		 Contains connections to FTP servers stored in the FTP Connections window.

    Quest.PersistentCache.xml

    		 Contains the private object annotation cache options (object notes, Lookup tables, and hidden columns). You can share these options with other Toad users in Tools | Options | Database | Cache.

    Settings.xml

    Contains many of the global configuration settings.

    SqlServerPlanPrefs.xml

    Used to generate SQL Server execution plans.

    ToadSupportBundle.zip

    Contains the last support bundle you generated.

    Folder

    Description

    Automation (temporary folder)

    Used by automation when executing automation scripts.

    Cache

    Used to spool cache database metadata to disk if enabled. The data is in binary format and can always be recreated by fetching it from the database.

    Context

    Contains settings that depend on the context within Toad including the following:

    • Adapter—Custom data editing statements.

    • Filter—Unnamed filters defined in the Object Explorer or Database Explorer.

    • Named Filter—Named filters defined in the Object Explorer or Database Explorer.

    • TYPE—Tabs that display on the right when you select an object in the Object Explorer or Database Explorer.

    Document Recovery

    		 Contains backup copies of Editor, Query Builder, and Database Diagram files saved if you have enabled Document Recovery in Tools | Options | Environment | General.

    Keyboard

    Contains custom keyboard shortcut layouts.

    Layouts

    Contains layouts for some areas in Toad, such as tool windows that automatically display in the Editor and column layouts for the Messages tab.

    ModuleSettings

    Contains general settings for various components in Toad, such as whether the data grid defaults to read-only, displays not null indicators, etc.

    Plugins

    Used by Toad plugin components.

    Session

    Contains desktop configurations, including toolbar customizations and tool window locations.

    SQLFormatter

    		 Contains pre-set and user created templates for formatting SQL, and the SQL statement used to preview formatting changes in the Formatting Options page.

    SQLRecall

    Contains the SQL statements saved by SQL Recall.

    Templates

    Contains the following templates:

    • Scripts—Startup scripts to run when connecting.   

    • Snippets—Code Snippet entries.

    • Reports—Report entries.