Quest® Log Reader for SQL Server
Version 1.2
Release Notes
DECEMBER 2007
The Log Reader for SQL Server is a SQL data-auditing and data-recovery tool that analyzes the SQL Server transaction log to display information on data and object changes.
With the Log Reader for SQL Server, you can view:
Recent transactions (those held in memory since the SQL Server instance was started)
The full database log (includes all transactions stored in the transaction log of an active database as well as transactions held in SQL Server memory).
All transactions stored in a database backup file (native or LiteSpeed).
New Features in Log Reader for SQL Server 1.2
Recover Table Wizard
Table History Wizard
SQL Server 2008 (CTP4) supported in preview mode
Command Line Interface
The following is a list of issues known to exist at the time of Log Reader for SQL Server release.
|
Feature |
Known Issue |
Change Request |
|
Vista Support |
Licensing If you update default license (15 days) with a new license by selecting Help | Registration from the Console menu, Log Reader for SQL Server updates the license for the user running the Console only. For other users, the default license is used. Workaroud: Use Registration form to update the license. |
CR#0221870 |
|
General |
When using the Find feature, Log Reader for SQL Server searches only through record values. |
CR#0208685 |
|
Log Reader for SQL Server does not support Find feature for BLOB values. |
CR#0208686 | |
|
Server Components installation |
Sometimes when installing Log Reader Server Components to a remote host, a "Write to file failed" error occurs. Workaroud:
Tip: You can use the EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLPath' command to define your server location.
EXEC sp_addextendedproc 'xp_qlr_version', 'xp_QuestLogReader.dll' EXEC sp_addextendedproc 'xp_qlr_logfile', 'xp_QuestLogReader.dll' EXEC sp_addextendedproc 'xp_qlr_loginfo', 'xp_QuestLogReader.dll' EXEC sp_addextendedproc 'xp_qlr_logread', 'xp_QuestLogReader.dll' |
CR#0216499 |
|
Script Generation |
CONTENT option for XML columns is not supported. |
CR#0202184 |
|
FILEGROUP and TEXTIMAGE_ON options are not supported (the script is not generated for the FILEGROUP and TEXTIMAGE_ON). For SQL Server 2005, partition scheme is also not supported. |
CR#0202183 | |
|
INSERT, UPDATE, or DROP commands for columns with BLOB values of 8000 bytes and more are detected, but script is not generated. |
CR#0202363 | |
|
When you use check log file changes option, Log Reader for SQL Server may reconstruct newly read log records incorrectly. Workaround: Click Refresh on the toolbar or use the Read Log wizard. |
CR#0208688 |
Log Reader for SQL Server v1.2 does not support automatic upgrade from version to version. You should manually uninstall the current version of Log Reader for SQL Server from your machine before installing a new one.
Trial version of Log Reader for SQL Server v1.2 has embedded default license (sysdate + 15 days).
Commercial version of Log Reader for SQL Server v1.2 requires:
To upgrade from trial version of Log Reader for SQL Server to commercial version:
Before installing Log Reader for SQL Server, ensure your system meets the following minimum hardware and software requirements:
| Platform |
32 bit or 64 bit Pentium III (Pentium IV recommended) or compatible processor. |
| Memory | Minimum 512MB. |
| Hard Disk Space | 100MB. Database files extracted from a backup require additional storage space depending on the size of the database. |
| Operating System |
Microsoft® Windows® XP Professional SP1 or 2, Microsoft® Windows® XP Professional - 64 bit Edition, Microsoft Windows 2000 Professional SP4, Microsoft Windows 2003 Microsoft Windows 2003 - 64 bit Edition, or Windows Vista. |
| Supported Databases |
Microsoft SQL Server 2000 SP4 - 32 bit, Microsoft SQL Server 2000 - 64 bit, Microsoft SQL Server 2005 RTM, SP1 or SP2 - 32 bit, Microsoft SQL Server 2005 RTM, SP1 or SP2 - 64 bit. |
| Additional Software | .NET Framework 2.0. |
This version was not tested for international operations. Only U.S. English configurations of this product and U.S. English datasets are fully supported. Support for non-ASCII characters and/or non-English configurations may work appropriately, but these configurations have not been tested and this product should be used with caution in these environments.
The Log Reader for SQL Server release package contains the following products:
| info@quest.com | |
| Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA | |
| Web |
Refer to our Web site for regional and international office information.
Quest Support is available to customers who have a trial version of
a Quest product or who have purchased a commercial version and have a
valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our
web self-service. Visit SupportLink at http://support.quest.com/.
From SupportLink, you can do the following:
View the Global Support Guide for a detailed explanation of support
programs, online services, contact information, and policy and procedures.
The guide is available at: http://support.quest.com/pdfs/Global%20Support%20Guide.pdf.
This document contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser's personal use without the written permission of Quest Software, Inc.
© 2007 Quest Software, Inc. ALL RIGHTS RESERVED.
Quest, Quest Software, the Quest Software logo, Aelita, AppAssure, Benchmark Factory, Big Brother, DataFactory, DeployDirector, ERDisk, Fastlane, Final, Foglight, Funnel Web, I/Watch, Imceda, InLook, IntelliProfile, Internet Weather Report, InTrust, IT Dad, JClass, Jint, JProbe, Knowledge Xpert, LeccoTech, LiteSpeed, LiveReorg, Matrix Insight, Matrix.Net, MIQ, NBSpool, NetBase, Npulse, PerformaSure, PL/Vision, Quest Central, RAPS, SharePlex, Sitraka, SmartAlarm, Speed Change Manager, Speed Coefficient, Spotlight, SQL Firewall, SQL Impact, SQL LiteSpeed, SQL Navigator, SQLab, SQLGuardian, SQLProtector, SQL Watch, Stat, Stat!, StealthCollect, Tag and Follow, Toad, T.O.A.D., Vintela, Virtual DBA, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.
This product includes software developed by Developer Express Inc. and Dundas Software Ltd.
If you have any questions regarding your potential use of this material, contact:
| Quest Software World Headquarters LEGAL Dept 5 Polaris Way Aliso Viejo, CA 92656 Email: legal@quest.com |
The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.