Dell DL4300 Appliance Users Guide - Page 74

Configuring nightly SQL attachability checks and log truncation

Get Dell DL4300 PDF manuals and user guides View all Dell DL4300 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 74 highlights

• SQL 7. Specify the credentials with administrative privileges for the Windows or SQL Server instances, described as follows: Text Box Description Username Enter a user name for logon permissions to the SQL server. Password Enter a password for SQL attachability. It is used to control logon activity. 8. 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. 9. Click Save. Attachability checks are now available to be run on the protected SQL Server databases. 10. In the Nightly Jobs window, click OK. Attachability checks are now schedule to occur with the nightly jobs. Configuring nightly SQL attachability checks and log truncation To configure nightly SQL attachability checks and log truncation: 1. In the left navigation area of the Core, select the machine for which you want to have nightly attachability checks and log truncation, and click SQL Server Settings. 2. Navigate to the Core Console. 3. Click Configuration → Settings. 4. In the Nightly Jobs section, click Change. 5. Select or clear the following SQL Server settings based on the needs of your organization: • Attachability Check Job • Log Truncation Job (simple recovery model only) 6. Click OK. The attachability and log truncation settings take effect for the protected SQL Server. Managing exchange database mountability checks and log truncation When using AppAssure to back up Microsoft Exchange Servers, mountability checks can be performed on all Exchange databases after every snapshot. This corruption detection feature alerts administrators of potential failures and ensures that all data on the Exchange servers is recovered successfully in the event of a failure. NOTE: The mountability checks and log truncation features only apply to Microsoft Exchange 2007, 2010, and 2013. Additionally, the AppAssure Agent service account must be assigned the Organizational Administrator role in Exchange. Configuring exchange database mountability and log truncation You can view, enable, or disable Exchange database server settings, including automatic mountability check, nightly checksum check, or nightly log truncation. 74

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
•
SQL
7.
Specify the credentials with administrative privileges for the Windows or SQL Server instances,
described as follows:
Text Box
Description
Username
Enter a user name for logon permissions to the SQL server.
Password
Enter a password for SQL attachability. It is used to control logon activity.
8.
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.
9.
Click
Save
.
Attachability checks are now available to be run on the protected SQL Server databases.
10.
In the Nightly Jobs window, click
OK
.
Attachability checks are now schedule to occur with the nightly jobs.
Configuring nightly SQL attachability checks and log truncation
To configure nightly SQL attachability checks and log truncation:
1.
In the left navigation area of the Core, select the machine for which you want to have nightly
attachability checks and log truncation, and click
SQL Server Settings
.
2.
Navigate to the Core Console.
3.
Click
Configuration
→
Settings
.
4.
In the
Nightly Jobs
section, click
Change
.
5.
Select or clear the following SQL Server settings based on the needs of your organization:
•
Attachability Check Job
•
Log Truncation Job (simple recovery model only)
6.
Click
OK
.
The attachability and log truncation settings take effect for the protected SQL Server.
Managing exchange database mountability checks and
log truncation
When using AppAssure to back up Microsoft Exchange Servers, mountability checks can be performed on
all Exchange databases after every snapshot. This corruption detection feature alerts administrators of
potential failures and ensures that all data on the Exchange servers is recovered successfully in the event
of a failure.
NOTE:
The mountability checks and log truncation features only apply to Microsoft Exchange 2007,
2010, and 2013. Additionally, the AppAssure Agent service account must be assigned the
Organizational Administrator role in Exchange.
Configuring exchange database mountability and log truncation
You can view, enable, or disable Exchange database server settings, including automatic mountability
check, nightly checksum check, or nightly log truncation.
74