Text Box DescriptionInput Location Select the location for importing the archive.User name To establish access to secure the archive, enter the logon credentials.Password Enter a password for accessing the archive.4. Click Check File to validate the existence of the archive to import.The Restore dialog box appears.5. In the Restore dialog box, verify the name of the source core.6. Select the agents to import from the archive.7. Select the repository.8. Click Restore to import the archive.Managing SQL attachabilityThe SQL attachability configuration enables the Core to attach SQL database and log files in a snapshotof a SQL server using a local instance of Microsoft SQL Server. The attachability test lets the Core checkfor the consistency of the SQL databases and ensures that all data files (MDF and LDF files) are available inthe backup snapshot. Attachability checks can be run on demand for specific recovery points or as part ofa nightly job.Attachability requires a local instance of Microsoft SQL Server on the AppAssure Core machine. Thisinstance must be a fully licensed version of SQL Server procured from Microsoft or through a licensedreseller. Microsoft does not allow the use of passive SQL licenses.Attachability supports SQL Server 2005, 2008, 2008 R2, 2012 and 2014. The account used to perform thetest must be granted the sysadmin role on the SQL Server instance.The SQL Server on-disk storage format is the same in both 64–bit and 32–bit environments andattachability works across both versions. A database that is detached from a server instance that isrunning in one environment can be attached on a server instance that runs in another environment.CAUTION: The version of SQL Server on the Core must be equal to or newer than the SQL Serverversion on all the agents with SQL Server installed.Configuring SQL attachability settingsPrior to running attachability checks on protected SQL databases, select a local instance of SQL Server onthe Core machine that will be used to perform the checks against the agent machine.NOTE: Attachability requires a local instance of Microsoft SQL Server on the AppAssure Coremachine. This instance must be a fully licensed version of SQL Server procured from Microsoft orthrough a licensed reseller. Microsoft does not allow the use of passive SQL licenses.To configure SQL attachability settings:1. Navigate to the Core Console. click the tab.2. Click Configuration → Settings.3. In the Nightly Jobs pane, click change.The Nightly Job dialog box appears.4. Select Attachability Check Job and then click Settings.72
