sqlserver2012误删除数据恢复3

Release notes: this document describes changes and enhancements made to ApexSQL Log Best viewed with 'WORD WRAP' unchecked -------------------------------------------------------------------------------------------------- Release: 2014.04.1133 Date: See http://www.apexsql.com/sql_tools_log_readme.aspx Description: Minor fix release -------------------------------------------------------------------------------------------------- Fixes: - The "Operation is missing UNDO/REDO script" error is encountered when creating UNDO or REDO script for DDL operations - The application does not show transaction for tables with page compression when database is in compatibility mode - The "System.Data.SqlTypes.SqlNullValueException" is thrown when transaction log contains incomplete data - The 'ApexSQL Log has stopped working' error is encountered when opening previously saved session while exporting process is running - Missing warning message that table ID is already mapped if multiple table mapping is initiated - Missing confirmation prompt when filter clear is initiated in GUI - The 'Group by' filters in the grid do not work - The "System.IO.FileNotFoundException" error is encountered when trying to open Options on a specific Windows Server 2003 - The Schema operations filter is missing filter by Schema - The 'Collection was modified; enumeration operation may not execute' error is encountered if a session is active during the application update - Deleted users are not shown if existing users are filtered out via the grid filter -------------------------------------------------------------------------------------------------- Release: 2014.03.1129 Date: November 19, 2014 Description: Minor fix release -------------------------------------------------------------------------------------------------- Fixes: - The "Error opening connection: Invalid connection string attribute" error is encountered when trying to connect to database when either server, username or password contains special characters ("';) - The application hangs during the creation of a REDO script when performing a conversion of datetime - The "Operation 'Drop object' is missing UNDO/REDO script" error is encountered when creating UNDO or REDO script for dropped DDL operations - The auditing process stops during "Initialize engine" step when auditing SQL 2005 database on Windows Server 2008 - The exporting process cannot be completed when exporting transaction log file backups without on-line transaction log to XML from CLI - The "External component has thrown an exception" error is encountered when trial period is extended on remote SQL Server -------------------------------------------------------------------------------------------------- Release: 2014.02.1121 Date: July 14, 2014 Description: Minor fix release -------------------------------------------------------------------------------------------------- Fixes: - The "Object reference not set to an instance of an object" error is encountered when using the "Old table ID mapping" option when transactions contain incomplete information - The application cannot complete auditing and the GUI hangs when auditing damaged transaction logs - The application cannot read compressed SQL Server 2014 backups - The batch script generated via the "Create batch file" option contains an incorrect value for the "/from" switch for the last 24 hours time range - The "System.ArgumentNullException - Value cannot be null" error is encountered when copying from the Undo or Redo script pane when no code is selected - The "Object reference not set to an instance of an object" error is encountered when exporting results into an HTML file via the CLI - The "At least one table must be selected when the DDL filter is not used" message is shown when no tables exist in the transaction log files added to the session, and navigation through Filter setup is blocked -------------------------------------------------------------------------------------------------- Release: 2014.01.1116 Date: May 20, 2014 Description: Minor feature, major fix release -------------------------------------------------------------------------------------------------- Enhancements: - The application now fully supports SQL Server 2014 - Automatic recognition of the database recovery model - An option to purge old application log files is added - Precision up to milliseconds is added to the Time range filters - Added the new "The session wizard auto loads SQL logs to analyze" option in the General section of the Options dialog Fixes: - The script created via the "Export to SQL BULK" cannot be executed - The "System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values" error is encountered when trying to connect to a database using the login mapped to a database user with the db_owner role - The "Object reference not set to an instance of an object." error is encountered if an incorrect path is selected in the Export undo script option - The "Column name or number of supplied values does not match table definition" error is encountered when running a script created via the Export to SQL file option - The "External error has thrown an exception" error is encountered when trying to manually activate a remote SQL Server instance - The "Adding a server failed" error is encountered when trying to activate a SQL Server instance with the same name as an instance already activated, but on a different machine - The Time range filter shows incorrect result set when the main grid is refreshed - The Users filter is not correctly filtering transactions in the main grid - When Select All Operations in Transactions is selected in the main grid, all operations in the selected transaction(s) are not shown in a specific case - The "Object reference not set to an instance of an object. Type: System.NullReferenceException" is encountered when creating the Undo or Redo script for the specific case - The application crashes when reading online transaction log files and server side auditing is used in a specific case - The Copy Rows to the Clipboard option does not copy the rows to the clipboard - The "The system cannot find the file specified" errors is logged in the application log files when trying to read specific transaction log backup files - The DDL filters are filtering the result set incorrectly after loading an application object filter .axof file - The Other option in the application Options | Script editor| Output Format and Editor cannot be configured - The "The constructor to deserialize an object of type 'ApexSql.Log.LogOperationData' was not found." error is encountered when clicking rows in the main grid in a specific case - Values for binary columns are not shown as binary when scripting user defined types that inherit the varbinary type - The Server selection in the Connect to server dialog in the Activation form is not locked in the activation dialog - When a backup is removed from the file list in the Select SQL logs to analyze step, transaction log details are removed from all backups in the file list - Some dialogs cannot be closed via the Escape key - The "The path is not of a legal form" error is encountered when incorrect path is provided in the Output path for Export/Create batch file - The Activation status is shown as Unknown when the trial expires on a server with no server side components - The application cannot access the online transaction log and the "The system cannot find the file specified" message is logged in the application log files in a specific case - The "Object reference not set to an instance of an object" error is encountered when creating the undo/redo script in a specific case - The session wizard cannot complete the auto loading of SQL logs process in a specific case - The "Export to SQL BULK" option generates