APPENDIX n SQL SERVER 2008 CONSIDERATIONS 328
nA
acceptable data loss, 305
acceptable downtime, 305
accidents, 6
Active Directory domain, 158
active/active configuration, 185??“186
active/active/active/ . . . configuration, 186
active/passive configuration, 183??“184
Address Windowing Extensions (AWE)
memory, 191
Advanced Encryption Standard (AES), 202
Advanced Technology Attachment (ATA), 247
AES (Advanced Encryption Standard), 202
agent proxies, 117??“122
alerts, 122??“123
allies, 317
ALTER DATABASE SET PARTNER OFF clause,
208
ALTER DATABASE statement, 68, 76
ALTER statement, 84
ALTER SYSTEM command, 323
ALTER TABLE statement, 84
Analysis Services, 182
architecture
of database snapshots, 229??“231
log shipping, 148??“150
basic, 149??“150
multiple standby servers, 150
archiving, 258, 268
array still function, 253
ATA (Advanced Technology Attachment), 247
authentication, 263??“264
automated backup failure, 8
automated failover, 200
automatic failback, 192
automatic page repair, 326
AWBackup command, 26
AW.bak file, 28, 53
AW.dif file, 29
AWE (Address Windowing Extensions)
memory, 191
nB
backing up and restoring, 75??“97
disaster scenarios, 96
filegroups, 90??“95
backing up, 90??“91
overview, 90
partial backups and restores, 92??“93
piecemeal restores, 94??“95
restoring, 91??“92
files, 87??“90
database files, 87??“89
differential backups, 88??“90
overview, 87
full-text indexes, 95??“96
overview, 75
Backup and Restore screen, 326
BACKUP command, 25, 44, 63, 290
BACKUP DATABASE command, 29, 32, 87,
92, 324
backup devices.
Pages:
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615