ProgramData\Quest Software\Toad Intelligence Central\ stores all user information, data source connection information and mappings for the Toad Intelligence Central server. This folder will potentially grow quite large if there are lots of snapshots and published objects.
The location of this folder was defined when the Toad Intelligence Central server was installed. See Install Toad Intelligence Central for more information.
The default location for the folder is C:\ProgramData\Quest Software\Toad Intelligence Central\ however the actual location may be quite different. For instance, due to the nature of this folder a decision may have been made to locate this folder on a separate drive.
|
Note: If you upgraded from Intelligence Central 3.2 (or earlier), the Toad Intelligence Central data folder could be located here: ProgramData\Dell\Toad Intelligence Central. |
If installing in a virtual machine environment, see Use Virtual Disk (VMDK) in Virtual Machine Installation for information about locating this folder on a virtual disk.
The folder has three sub folders. When making a copy of this folder ensure you copy all content (files and subfolders):
|
Note: The C:\ProgramData folder is hidden by default. To see the folder, from Windows® Explorer click Tools | Folder Options, from the Folder Options dialog click View | Show hidden files, folders, and drives. |
All user information, data source connection information and mappings for the Toad Intelligence Central server are stored in ProgramData\Quest Software\Toad Intelligence Central\. A backup of the Toad Intelligence Central server is a backup of this folder including sub folders.
|
Note: If you upgraded from Intelligence Central 3.2 (or earlier), the Toad Intelligence Central data folder could be located here: ProgramData\Dell\Toad Intelligence Central. |
The Toad Intelligence Central server must be stopped while the backup is made. You may want to ensure the time of the backup does not conflict with tasks Toad Intelligence Central has been scheduled to do, such as refreshing a snapshot or executing a Toad Data Point automation script.
If a backup is taken while Toad Intelligence Central services are still running the backup will be corrupted; you will not be able to restore or recover from the corrupted backup.
If your standard backup procedure involves taking an image or full backup of the hard disk then use Windows® Scheduler as documented in this section to schedule the Toad Intelligence Central backup.
Please make a note of the Toad Intelligence Central version when you create the backup. The backup can only be restored to this version of Toad Intelligence Central. For example, a backup from Toad Intelligence Central 5.0 can only be restored to Toad Intelligence Central 5.0. It cannot be restored to Toad Intelligence Central 5.3. If you need to restore the backup data, refer to Restore Toad Intelligence Central.
These steps illustrate what is involved in the backup process. Ensure Toad Intelligence Central server services have stopped. Restart Toad Intelligence Central server services once backup is complete.
Toad Intelligence Central is distributed with an executable file that automatically follows the steps of the manual backup.
From the Windows Server® that hosts the Toad Intelligence Central server
Execute the backup.bat command. For example: backup.bat "c:\backup folder"
Optionally, enclose the target folder for the backup in quotes. In the example the target folder is "c:\backup folder". If the target folder is not specified then the backup will be saved to: ProgramData\Quest Software\Toad Intelligence Central\backup
Verification:
Use Windows Scheduler to schedule a local backup of the data files. Follow this procedure if your standard backup procedure involves taking an image or full backup of the hard disk.
Open the Windows Task Scheduler.
From the Windows server that hosts Toad Intelligence Central, log in as Administrator. Click Start | Control Panel | System and Security | Administrative Tools | Task Scheduler.
Click Action | Create task.
On the General tab, give the task a Name and select Run with highest privileges.
On the Triggers tab, click New. Set your required back up schedule. As a consideration, ensure this schedule does not conflict with the schedules set for Toad Intelligence Central such as snapshot refresh and Toad Data Point automation script execution. Ensure the schedule is set to complete prior to the full machine backup.
On the Actions tab, click New.
Follow these instructions to restore a backup of the Toad Intelligence Central server. To backup the Toad Intelligence Central server see Backup the Toad Intelligence Central server.
|
Note: Restore to the same version of Toad Intelligence Central as the backup. For example, a backup from Toad Intelligence Central 5.0 can only be restored to Toad Intelligence Central 5.0. It cannot be restored to Toad Intelligence Central 5.3. |
Copy the entire backed up ProgramData\Quest Software\Toad Intelligence Central\ folder to the ProgramData\Quest Software\Toad Intelligence Central\ folder used by the installation.
|
Note: If you upgraded from Intelligence Central 3.2 (or earlier), the Toad Intelligence Central data folder could be located here: ProgramData\Dell\Toad Intelligence Central. See Toad Intelligence Central Data Folder for more information. |
Copy ProgramData\Quest Software\Toad Intelligence Central\ from one Toad Intelligence Central server installation to another. ProgramData\Quest Software\Toad Intelligence Central\ stores all user information, data source connection information and mappings. See Toad Intelligence Central Data Folder for more information.
|
Note: If you upgraded from Intelligence Central 3.2 (or earlier), the Toad Intelligence Central data folder could be located here: ProgramData\Dell\Toad Intelligence Central. |
Before migrating, review the following potential issues.
Issue | Issue Description and Workaround |
---|---|
Automation scripts fail to run successfully after migration |
In Toad Intelligence Central 2.7.2 (or earlier), attempting to run an Automation script after migration can result in a null password database error (for example, “ORA-01005: null password given; logon denied”). If you encounter this issue, contact Support or implement the following workaround. Workaround: To prevent this issue, before migrating to another server, upgrade your current Toad Intelligence Central installation to version 3.0 (or later). Then perform the migration. |
Automation scripts fail to run successfully after migration |
In Toad Intelligence Central 4.3 (or earlier), after migrating data files from one Toad Intelligence Central server installation to another, the migrated Automation scripts set to run under an account other than the default user account do not run successfully. Workaround: Contact Quest Support for a workaround. See the following knowledge base article for more information: https://support.quest.com/toad-intelligence-central/kb/250694/migrating-the-tic-data-folder-causes-published-scripts-execution-to-fail. |
Error fetching build_arch for Intelligence Central server |
A known issue found when connecting to Toad Intelligence Central following migration generates the following error: "Error fetching build_arch for Intelligence Central server." Solution: If you encounter this error, right click the Data folder in ProgramData\Quest Software\Toad Intelligence Central\ and select Properties. On the General tab in the Attributes section ensure Read-only is NOT selected. |
Ensure the version of Toad Intelligence Central is the same for both installations before migration. Upgrade one of the Toad Intelligence Central installations if necessary.
For the Toad Intelligence Central server you are migrating from:
Make a copy of ProgramData\Quest Software\Toad Intelligence Central\.
For the Toad Intelligence Central server you are migrating from:
Data connectivity
Some data source connections make use of drivers installed on the Intelligence Central server. Ensure all drivers required by the Intelligence Central server data source connections are installed on the new Intelligence Central server.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center