Applies to
ApexSQL Diff, ApexSQL Data Diff, ApexSQL Doc, ApexSQL Script, ApexSQL Complete, ApexSQL Search, ApexSQL Refactor
Summary
This article explains what to do when ‘Only customers with a current support and upgrades contract can upgrade for free…’ warning is encountered when application update is initiated for free or Community edition ApexSQL tools.
Applies to
ApexSQL Log 2014
Summary
This article explains how to manually install and uninstall the server side components when it is not possible to utilize ApexSQL Log installer or when server side components need to be (un)installed on the passive cluster node.
Applies to
ApexSQL Recover, ApexSQL Log
Summary
This article explains how to manually edit script created by ApexSQL Recover or ApexSQL Log which contains ‘$’ sign in order for it to be executable by sqlcmd
Applies to
ApexSQL Trigger
Symptoms
When opening the project file on another machine, the error appears:
Applies to
ApexSQL Data Diff
Symptoms
The “Cannot insert the value NULL into column ‘ColumnName’, table ‘TableName; column does not allow nulls. INSERT fails.” error is encountered when running ApexSQL Data Diff synchronization script.
Applies to
ApexSQL Doc
Summary
This article describes why CHM documentation output cannot be seen and how to fix it
Applies to:
ApexSQL Backup
Symptoms:
In the process of selecting a SQL Server that will host the ApexSQL Backup Central Repository Database the ‘Cannot connect to server’ error is encountered if selected server has a default named instance.
Applies to:
ApexSQL Backup
Symptoms:
If a destination database recovery state is not set to the no-recovery (restoring) state, log shipping job will fail during the process of transaction log restore with the "The log or differential backup cannot be restored because no files are ready to rollforward. RESTORE LOG is terminating abnormally" error.
Applies to:
ApexSQL Backup
Symptoms:
During the process of Log shipping, the restore transaction log job fails and the ‘System.Data.SqlClient.SqlError: The log in this backup set begins at LSN, which is too recent to apply to the database. An earlier log backup that includes LSN can be restored.’ error is encountered, and whole process fails.
Applies to:
ApexSQL Data Diff
Symptoms:
If very large databases are compared, in some cases, the memory limitation of the application may be exceeded. If so this will produce an Out Of Memory error.
