DL4300 Appliance
Settings and functions for protected SQL servers
224
Settings and functions for protected SQL servers
If you are protecting a Microsoft SQL Server in your Core, there are additional settings you can configure in the
Rapid Recovery Core Console, and there are additional functions you can perform.
A single setting, Attachability, is available in the Core Console related to SQL Server.
Rapid Recovery Core lets you perform a SQL attachability check to verify the integrity of recovery points
containing SQL databases. This action checks the consistency of SQL databases and ensures that all supporting
MDF (data) and LDF (log) files are available in the backup snapshot.
In previous releases, SQL attachability checks have historically required a licensed version of SQL Server on
the Core machine. Rapid Recovery Core now provides the ability to perform SQL attachability checks from
an instance of SQL Server on the Core, or from a licensed version of SQL Server on a protected SQL Server
machine.
The attachability settings let you specify which licensed version of SQL Server is used to perform this check. For
more information about configuring attachability settings, see
Managing Core SQL attachability settings
For more information on SQL attachability, see
Following are functions you can perform for a SQL server protected by the Core.
•
Specify SQL Server credentials. Rapid Recovery Core lets you set credentials so the Core can authenticate to the
SQL server to obtain information. You can set credentials for a single protected SQL Server machine, or set default
credentials for all protected SQL Servers.
For more information about setting credentials for SQL servers, see
credentials for a SQL Server machine
•
Truncate SQL logs. When you force log truncation of SQL Server logs, this process identifies the available space on the
protected server. This process does not reclaim any space.
For more information about truncating SQL Server logs on demand, see
log truncation for a SQL machine
•
Force an attachability check of a SQL Server. This function checks the consistency of SQL databases and ensures that
all supporting MDF (data) and LDF (log) files are available in the backup snapshot.
For more information about forcing an attachability check for SQL servers on
Forcing a SQL Server attachability check
Other than specifying credentials, each of the functions described in the preceding list can be accomplished
on demand, and can also be configured to occur as part of the nightly jobs performed for the Core. For more
information about the tasks you can schedule as nightly jobs, see
Configuring nightly jobs for the Core
.
Parent topic
Setting credentials for a SQL Server machine
You must add the SQL Server machine to protection on the Rapid Recovery Core before performing this
procedure. For more information about protecting machines, see
.
Once you protect data on a Microsoft SQL Server machine, you can set login credentials for a single instance, or
for all SQL Servers, in the Rapid Recovery Core Console.
Complete the steps in this procedure to set credentials for each SQL Server.
1. In the left navigation area of the Rapid Recovery Core Console, select the protected SQL Server machine
for which you want set credentials.