Configuring Sql Attachability Settings - Dell PowerVault DL4000 User Manual

consistency of the SQL databases and ensure that all data files (MDF and LDF files) are available in the backup
snapshot.
Attachability checks can be run for specific recovery points on demand or as part of a nightly job. Attachability requires
the presence of a local instance of Microsoft SQL Server on the Core. This is a passive instance with no active
databases or queries. Attachability supports SQL Server 2005, 2008, and 2008 R2. The account used to perform the test
must be granted the sysadmin role on the SQL Server instances.
NOTE: The SQL Server on-disk storage format is the same in both 64-bit and 32-bit environments and attachability
works across both versions. A database that is detached from a server instance that is running in one environment
can be attached on a server instance that runs in another environment.
CAUTION: The version of SQL Server on the Core has to be equal to or newer than the SQL Server version on all the
agents with SQL Server installed.

Configuring SQL Attachability Settings

Prior to running attachability checks on the protected SQL databases, you must first select a local instance of SQL
Server against which the attachability checks to perform.
To configure SQL attachability settings:
1. Navigate to the AppAssure 5 Core, and then click the Configuration tab.
2. From the Manage option, click Attachability.
The Attachability Check Settings window is displayed.
3. Select the local SQL Server instance to use to perform attachability checks for the protected SQL databases.
You can choose from:
– SQL Server 2005
– SQL Server 2008
– SQL Server 2008 R2
4. Select the credential type.
You can choose from:
– Windows
– SQL
5. Specify the credentials with administrative privileges for the Windows or SQL Server instances, as described
below.
Text Box
Username
Password
6. Click Test Connection.
NOTE: If you entered the credentials incorrectly, a message is displayed to alert you that the credentials test
failed. Correct the credential information and run the connection test again.
7. Click Apply.
Attachability checks are now available to be run on the protected SQL Server databases.
Description
Enter a user name for logon permissions to the SQL server.
Enter a password for SQL attachability. It is used to control logon activity.
77