Managing Core SQL Attachability Settings (4041311)

SQL attachability checks occur as part of the Rapid Recovery nightly jobs. To ease licensing costs, Rapid Recovery gives you two options for performing attachability checks:

1. Using a licensed instance of SQL Server installed on the Rapid Recovery Core machine.
   • If upgrading from AppAssure this will remain your default option.
   • If this is a new install you will need to select this option in Core Settings in order to use it.
   • NOTE: The instance of SQL Server installed on the Core must be equal to or higher than the highest version of SQL being protected.
   • For example, if you are protecting two SQL Agents, one is SQL 2008 R2 Enterprise and one is SQL 2012 Standard, the Core must have SQL 2012 Enterprise installed for attachability y checks to work for both Agents.
2. Using the instance of SQL Server already installed on your protected machine.
   • This second option is now the default setting for new installs.
   • If upgrading from AppAssure you will need to select this option in Core Settings if you wish to use it.
3. NOTE:
   • This is a global setting. Whatever option is selected will be for all SQL Agents.
   • Agent side attachability requires a Rapid Recovery Agent to be installed.
   • See Rapid Recovery Release Notes located at Rapid Recovery Technical Documentation, to insure your SQL Server operating systems meets the requirements to install the Rapid Recovery Agent

For the most up-to-date and detailed information regarding SQL attachability, see Managing Core SQL attachability settings in the Rapid Recovery User Guide located at Rapid Recovery Technical Documentation.

1. Navigate to the Rapid Recovery Core Console and click Settings
2. From the list of Core settings on the left side of the Settings page, click Attachability
3. To use the SQL Server instance installed on the protected SQL Server machine, select Use SQL Server on the protected machine.
4. To use the SQL Server instance installed on the Rapid Recovery Core, select Use SQL Server on the Core, and then enter the authentication information required.
5. Click Test Connection. NOTE: If you entered the credentials incorrectly, a message displays to alert you that the credentials failed. Correct the credential information and test the connection again. Even when the connection succeeded, please ensure the account has the necessary permissions to mount recovery points (i.e. read and write permission on %ProgramData%\AppRecovery\MountPoints folder)
6. After you are satisfied with your changes, click Apply.