SQL Log Rescue
Latest version: 1.2
Knowledge Base
Disabling live log retrieval
Category: How do I?
Date: 21 Apr 2009
Product: SQL Log Rescue
Versions: 1.2
When attempting to retrieve the log file from SQL Server, Log Rescue may time out or throw other errors because there is a hung transaction, or other problems with the database log. In these cases, it is possible to forgo the log analysis and substitute any transaction log backup files that may be available in place of the live log.
In order to cause SQL Log Rescue to skip analysis of the live log files, first create a new DWORD value in the following registry key called "Retrieve live log", and set the value to 0.
HKEY_CURRENT_USER\Software\Red Gate\SQL Log Rescue
This registry value can be created using the Windows Registry Editor (start->run, enter REGEDIT.exe, RETURN).
Once this is done, restart SQL Log Rescue and set up a new project, specifying a database, full backup, and an unbroken chain of log backups starting after the specified full backup file. The analysis will show all of the data transactions that had occurred since the full backup, taking them from the log backup files.
Document ID: KB200806000269 Keywords: SQL,Log,Rescue,registry,files
Was this article helpful?
SQL Log Rescue
- There was no relevant information about this database in the backup
- Log Rescue timing out when uncommitted transactions exist on server
- Installation fails because of MDAC requirement
- Timeout expired while examining database logs
- No full database backup specified message
- Disabling live log retrieval
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Log Rescue
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
- Installing Red Gate SQL Server tools across a network
