Managing Sql Attachability; Configuring Sql Attachability Settings - Dell DL4000 User Manual
Tape library
Hide thumbs
Also See for DL4000:
- User manual (163 pages) ,
- Owner's manual (101 pages) ,
- Deployment manual (22 pages)
Table of Contents
Advertisement
Text Box
Input Location
User name
Password
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 attachability
The SQL attachability configuration enables the Core to attach SQL database and log files in a snapshot
of a SQL server using a local instance of Microsoft SQL Server. The attachability test lets the Core check
for the consistency of the SQL databases and ensures that all data files (MDF and LDF files) are available in
the backup snapshot. Attachability checks can be run on demand for specific recovery points or as part of
a nightly job.
Attachability requires a local instance of Microsoft SQL Server on the AppAssure Core machine. This
instance must be a fully licensed version of SQL Server procured from Microsoft or through a licensed
reseller. 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 the
test 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 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 must 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 protected SQL databases, select a local instance of SQL Server on
the 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 Core
machine. This instance must be a fully licensed version of SQL Server procured from Microsoft or
through 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
Description
Select the location for importing the archive.
To establish access to secure the archive, enter the logon credentials.
Enter a password for accessing the archive.
Advertisement
Table of Contents
