Knowledgebase and Troubleshooting articles round-up – October 17th, 2014

Here is the summary of our latest knowledgebase and troubleshooting articles:

How to manually install ApexSQL Log server side components – ApexSQL Log
In this article we described how to manually install ApexSQL Log server side components when it is not possible to utilize ApexSQL Log installer or when server side components need to be installed on the passive cluster node.

How to manually install ApexSQL Recover server side components – ApexSQL Recover
In this article we explained how to manually install the server side components when it is not possible to utilize ApexSQL Recover installer or when server side components need to be installed on the passive cluster node.

Using ApexSQL Script Command Line Interface (CLI) switches – ApexSQL Script
In this article we explained the ApexSQL Script CLI switches, and their usage through the various examples.

How to clean ApexSQL Log temporary files – ApexSQL Log
In this article we explained the content of ApexSQL Log temporary files and correct approach to clear them in order to free disk space.

Recovery possibilities when a database is in simple recovery mode – ApexSQL Recover
In this article we explained how to use ApexSQL Recover’s MDF scraping option to recover directly from an MDF file and offered advice on how to increase the amount of recovered data.

Using ApexSQL Log when local installation and remote installation of server side components isn’t possible – ApexSQL Log
In this article we explained how to use ApexSQL Log even when installation of ApexSQL Log and/or server side components is not possible/allowed on the server machine due to performance, security, or any other reasons.

How to get a complete audit trail for UPDATE transactions – ApexSQL Log
In this article we explained how to get all UPDATE transaction records when audited data isn’t shown with messages including “Data unavailable”, “No data available for selected operation” and “Record change history could not be constructed”.

How to increase auditing and exporting performance in ApexSQL Log – ApexSQL Log
In this article we explained methods that can be used to improve auditing performance and speed-up the exporting operation with ApexSQL Log.

ApexSQL Log doesn’t show/recover all transactions – ApexSQL Log
In this article we explained why ApexSQL Log shows only some of the transactions you expect to see and how to show/recover all of them

ApexSQL Audit installation fails and changes are rolled back silently without any warning or dialog – ApexSQL Audit
In this article we presented solution in case ApexSQL Audit installation fails when.NET framework 4.5 in not installed on the system, or is corrupted.

SQL Server can’t be added for monitoring due to blank control displays in the ‘Add server’ dialog – ApexSQL Monitor
In this article we offered solution for a case when a SQL Server instance can’t be added for monitoring, due to the fact that the Add server dialog buttons are blank and user interaction is not allowed

The ApexSQL Monitor repository database transaction log file continues to grow even after data was deleted using the Purge data option – ApexSQL Monitor
In this article we explained how continuous growth of the ApexSQL Monitor repository database log file can use up free hard disk space, and to resolve it.

The “Service is not located. Please try different machine name or port, or verify that the service is running” error – ApexSQL Monitor
In this article we described a case when the ApexSQL Monitor encounters the error “Service is not located. Please try different machine name or port, or verify that the service is running” after successful completing of the installation and described resolution steps.

Internal error: Expression error ‘Runtime Error (at 202:207): External exception E0434352 – ApexSQL Monitor
In this article we explained in which cases “Internal error: Expression error ‘Runtime Error (at 202:207): External exception E0434352” is encountered and described a workaround.

Cannot configure auditing for SQL Servers with caps sensitive collation – ApexSQL Audit
In this article we explained why auditing options cannot be configured for SQL Server with caps sensitive collation, and announced upcoming solution.

The ApexSQL Monitor service cannot be located from the user console installed on the remote computer – ApexSQL Monitor
In this article, we described resolution for the case when the ApexSQL Monitor service cannot be located and the warning message is displayed after starting the user console installed on a remote network computer.

The “System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation” error – ApexSQL Monitor
In this article, we presented a workaround for the case when the “System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation” error is encountered when user attempts to enter the global metrics period value immediately after selecting the Metrics view

October 17, 2014