How to manually install ApexSQL Recover server-side components

Applies to
ApexSQL Recover

Summary
This article explains 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.

Description
When ApexSQL Recover is installed in a cluster environment, the server-side components cannot be installed on the passive nodes. To perform the installation of server-side components in an environment that prevents installation from the ApexSQL installation wizard, the following steps need to be done:

  1. If old server-side components already exist on the target node, uninstall them and delete the remaining files from the ApexSQL Recover ‘Binn’ folder from this location: C:\ProgramData\ApexSQL\ApexSQLRecover\<Instance_Name>\Binn\
  2. Install ApexSQL Recover to any other available system that doesn’t require manual installation – default installation does the trick
  3. From the ApexSQL Recover installation folder (default location is C:\Program Files\ApexQL\ApexSQL Recover 2014), copy ApexSQLRecoverXprocsx64.dll or ApexSQLRecoverXprocsx86.dll file, depending of the system architecture (x64 or x86), to the target SQL server ‘Binn’ folder (default ‘Binn’ folder location is C:\Program Files\MicrosoftSQL\<Instance_Name>\MSSQL\Binn)
  4. Rename the copied file to ApexSQLRecoverXprocs.dll

  5. Run the following install script on the target SQL server:

    IF NOT EXISTS (
		SELECT *
		FROM master.dbo.sysobjects
		WHERE NAME = 'xp_ApexSQLRecover'
		)
	EXEC master.dbo.sp_addextendedproc 'xp_ApexSQLRecover'
		,'ApexSQLRecoverXprocs.DLL'

  1. Copy following files from the ApexSQL Recover installation folder to the target SQL server machine folder:

    C:\ProgramData\ApexSQL\ApexSQLRecover\<Instance_Name>\Binn\

    Note: In case you are installing to default server instance (MSSQL), the ‘(local)’ must be used in place of the ‘<instance name> ‘ (e.g. C:\ProgramData\ApexSQL\ApexSQLRecover\(local)\Binn\)

    The files list:

    ApexSQL.Activation.dll
    ApexSQL.Base.dll
    ApexSQL.Common.Decry.dll
    ApexSQL.Common.Logging.dll
    ApexSQL.Common.Scripting.dll
    ApexSQL.Engine.dll
    ApexSQL.Recover.dll
    ApexSQL.Recover.CommunicationProtocol.dll
    ApexSQL.Recover.Exports.dll
    ApexSQLLogCorex64.dll or ApexSQLLogCorex86.dll (depending on the architecture)
    ApexSQLRecoverServerHelperx64.exe or ApexSQLRecoverServerHelperx86.exe (depending on the architecture)
    ApexSQLRecoverServerRecoverer.exe
    ApexSQLServerActivation.exe
    atl90.dll
    Microsoft.VC90.ATL.manifest
    Microsoft.VC90.CRT.manifest
    msvcm90.dll
    msvcp90.dll
    msvcr90.dll

  2. The following files that have just been copied need to be renamed (depending on the system architecture):

    • ApexSQLLogCorex64.dll or ApexSQLLogCorex86.dll should be renamed to ApexSQLRecoverCore.dll

    • ApexSQLRecoverServerHelperx64.exe or ApexSQLRecoverServerHelperx86.exe should be renamed to ApexSQLRecoverServerHelper.exe

    3. This enables ApexSQL Recover to audit target SQL server and concludes the manual installation process.

    Related posts:

    1. ApexSQL Recover evaluation guide for first time users
    2. SQL disaster recovery article index
    3. Does ApexSQL Log install anything on my SQL Server?
    4. How to manually uninstall ApexSQL Recover server-side components
    5. Recover table data from a database backup – ApexSQL Recover