DL4300 Appliance
Settings and functions for protected SQL servers
225
The Summary page displays for the protected SQL Server.
2. On the Summary page, from the links at the top of the page, click the downward-facing arrow to the right
of the SQL menu, and then from the resulting drop-down menu, do one of the following:
•
If you want to set default credentials for all SQL Server database instances, click Set Default Credentials for All
Instances, and in the Edit Default Credentials dialog box, do the following:
1. In the User name text field, enter the user name for a user with permissions to all associated SQL
servers; for example, Administrator (or, if the machine is in a domain, [domain name]\Administrator).
2. In the Password text field, enter the password associated with the user name you specified to
connect to the SQL server.
3. Click OK to confirm the settings and close the dialog box.
•
If you want to set credentials for a single SQL Server database instance, click the display name of the protected
SQL Server machine, and then in the Edit Instance Credentials dialog box, do the following:
1. Select the credential type (Default, Windows, or SQL)
2. In the User name text field, enter the user name for a user with permissions to the SQL server; for
example, Administrator (or, if the machine is in a domain, [domain name]\Administrator).
3. In the Password text field, enter the password associated with the user name you specified to
connect to the SQL server.
4. Click OK to confirm the settings and close the dialog box.
Parent topic
Forcing log truncation for a SQL machine
Log truncation is available for machines that use SQL Server. Complete the steps in this procedure to force log
truncation.
NOTE:
When conducted for a SQL machine, truncation identifies the free space on a disk, but does not
reduce the size of the logs.
1. In the left navigation area of the Rapid Recovery Core Console, select the machine for which you want to
force log truncation.
The Summary page appears for the protected machine.
2. From the Summary page (or from any page for this protected machine), at the top of the page, click the
SQL drop-down menu and select Force Log Truncation.
3. Click Yes to confirm that you want to force log truncation.
Parent topic
About SQL attachability
The SQL attachability feature lets the Rapid Recovery Core attach SQL master database files (.MDF files) and
log database files (.LDF files) to a snapshot of a protected SQL Server. The snapshot is captured using a local
instance of Microsoft SQL Server.
Issues relevant for Rapid Recovery users protecting SQL Server machines include which instance of SQL Server
performs attachability, and the method of performing SQL attachability (on demand, or as part of nightly jobs).
The attachability check lets the Core verify the consistency of the SQL databases and ensures that all 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.
To perform the SQL attachability check on demand, see
Forcing a SQL Server attachability check
SQL attachability once daily, at the time specified for your nightly job operations, enable the option Check
attachability for SQL databases in nightly jobs. For more information about setting nightly jobs for the Core, see
Configuring nightly jobs for the Core
. For more information about setting nightly jobs for a specific machine (in this
case, a protected SQL Server), see
Customizing nightly jobs for a protected machine
.