project, 314??“315
lack of awareness, 305??“311
lack of management/executive buy-in,
311??“313
lack of staff buy-in, 313??“314
overview, 304??“305
silos, 317
scenarios, 278??“290
environmental disasters, 286??“287
environmental/hardware disasters,
281??“285
media disasters, 289??“290
overview, 278
process disasters, 287??“289
user/process disasters, 278??“281
testing, 277??“278
disaster scenarios, 96, 240??“241
disaster-mitigation technique, 172
disasters
environmental, 281??“287
hardware, 281??“285
media, 289??“290
process, 278??“281, 287??“289
user, 278??“281
???Disconnect users??? option, 163
discord, 303
distribution databases, restoring, 68
DLT (Digital Linear Tape), 257
DML (Data Manipulation Language), 327
DNS (domain name system), 5
documentation, 276
domain name system (DNS), 5
doomsayers, 296??“297
DROP command, 233
DROP DATABASE command, 233
DSNs (Data Source Names), 166, 167, 169
DUMP LOG command, 25
nE
eight-node cluster, 181, 186
electromagnetic fields, 289
electronic documentation, 276
emergency mode, 37
encryption, 217
end documentation, 272
endpoints, 201??“202
endpoints table, 208
Environment failure, 9
environmental, 72
backup location, 38
backup method, 39
recovery mode, 38
environmental disasters, 6, 281??“287
environmental failure, 96, 192
environmental log shipping, 171
error checking, 31??“32
ESCAPE_NONE macro, 117
event notification, 328
ExpirationDate field, 49
external heat issues, 266
external storage system, 192
external support, 277
nF
failback, 148, 173
in clusters, 191??“192
High Availability mode, 210??“211
High Performance mode, 207
High Protection mode, 208??“209
to primary server, 169??“170
failed failover, 190
failed motherboard, 7
failed node, 191
failing disk drive, 7
failover, 148, 164??“169, 173
in clusters, 188??“191
planning for, 188??“190
server resource planning, 190
SQL clustering and AWE memory, 191
copying dependent items, 166
High Availability mode, 210
High Performance mode, 207
High Protection mode, 208
identifying database state, 165
overview, 164
recovering standby databases, 165??“166
redirecting clients to new primary server,
166??“169
changing DSNs on client machines,
166??“167
overview, 166
redirecting DNS, 169
renaming server and changing IP
address, 167??“169
restoring log backups, 165
failover clustering, 274
failover event, 181
Failover Partner fallback, 206
failover scenarios, 193
FamilyCount field, 51
FamilySequenceNumber field, 51
fast file initialization, 58??“59
nINDEX 333
fast restore, 128??“131
overview, 128
potential approach, 129??“130
requirements, 128??“129
risks, 130??“131
file backups, 321
File Transfer Protocol over SSL (FTPS), 150
file/filegroup backups, 11, 149, 321
Filegroup column, 79
FileGroupName field, 50
filegroups, 76??“87, 234
assigning objects to, 81??“84
creating objects in, 81??“83
moving objects to, 83??“84
backing up, 90??“95
overview, 90
partial, 92??“93
creating, 76??“79
default, 80??“81
overview, 76
restoring, 90??“95
overview, 90
partial, 92??“93
piecemeal, 94??“95
strategies, 84??“87
isolating specific tables, 86
partitioning tables, 86
reducing backup/restore time, 86??“87
separating clustered from nonclustered
indexes, 85
separating read-only and read/write
tables, 85
FileID field, 50
FILENAME property, 325
files, backing up and restoring, 87??“90
database files, 87??“89
differential backups, 88??“90
overview, 87
FILESTREAM data, 324??“326
filestream.
Pages:
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619