Use the System Diagnostics window to collect verbose logs that can be used for troubleshooting by Idera Support. By default, high-level logging is always enabled for SQL Virtual Database activities and events.
To access system diagnostics:
- On the SQL Virtual Database Welcome window, click Help & More.
- Click System Diagnostics .
To collect the logs:
- Ensure the Enable Debug Mode option is selected.
- Click the collection button. SQL VDB creates a zipped folder of the specified log files and places this folder on the Windows desktop. By default, the zip folder is named IderaSQLvdbCollectionLogInstanceNameTimeStamp.zip.
- Email the zipped log folder to Idera Support.
To collect the logs for issues encountered when installing SQL Virtual Database:
- Start the Windows Command Prompt.
- Navigate to the installer directory (by default, C:\Documents and SettingsUser Name\My Documents).
Type one of the following commands:
Server Type Installation Command x86 (32-bit) msiexec /i SQLvdb.msi /l*v C:\MyFolder\SQLvdb_install.log x64 (64-bit) msiexec /i SQLvdb-X64.msi /l*v C:\MyFolder\SQLvdb_install.log - Step through the setup program until you recreate the issue. SQL Virtual Database generates the resultant log file in the location you specified.
- Email the log file to Idera Support.