. ., 186
active/passive, 183??“184
multiple instances, 187
overview, 183
database mirroring and, 275
database snapshots and, 275
disaster categories and, 192??“193
failback in, 191??“192
failover in, 188??“191
planning for, 188??“190
server resource planning, 190
SQL clustering and AWE memory, 191
log shipping and, 275
overview, 175??“176
SQL Server, 181??“182
nINDEX 330
cluster-unaware application, 182
cluster-unaware applications, 182??“183
CMDExecProxy proxy, 121
Codepage field, 49
cold backup, 37
Collation field, 49
communication, 317
communication protocol, 256
Community Technology Preview (CTP)
programs, 195
Compressed_Backup_Size field, 324
Compression field, 49
Configure Security wizard, 214??“220
configuring
database mirroring feature, 211??“223
log shipping, 151??“172
disaster categories and, 171??“172
failback to primary server, 169??“170
failover, 164??“169
manual, 152
manual log shipping, 155
monitoring environment, 170??“171
overview, 151??“152
in SQL Server 2000, 155??“156, 163
consulting cost, 106??“108
CONTINUE_ON_ERROR clause, 63
CONTINUE_ON_ERROR command, 31
CONTINUE_ON_ERROR option, 65
continuous data protection (CDP), 259
conversant, 267
COPY_ONLY command, 36
copying dependent items, 166
copy-only backup, 36
copy-on-write process, 229
corrupted active backup tape, 7
cost, for BRPs, 105??“113
consulting cost, 106??“108
design, 112
hardware cost, 106
maintenance and troubleshooting, 113
overview, 105??“111
software cost, 106
testing, 112
training, 111
cost-justification, 311, 313
cost-of-business spending, 312
CREATE DATABASE command, 76, 231, 242
Create Endpoint wizard, 215
CREATE INDEX statement, 81
CREATE statement, 76, 81
CREATE TABLE statement, 81
Creation_Date field, 238
credential proxies, 119
CTP (Community Technology Preview)
programs, 195
nD
damaged archival tape, 7
damaged cables, 7
Data Definition Language (DDL), 327
Data Encryption Standard (DES), 202
data loss, 104??“105, 131??“133, 142, 146
Data Manipulation Language (DML), 327
data pages, restoring, 64??“65
data partitioning, 258
Data Source Names (DSNs), 166, 167, 169
data transfer, 142
database administration (DBA), 4, 283
database backups, 13??“41
additional considerations, 37
backup file sizes, 29??“30
copy-only backup, 36
differential backup, 29
disaster categories and, 38??“39
error checking, 31??“32
full backup, 28
log backup, 28
mirrored backup, 35??“36
overview, 13??“14
securing backups, 32
SQL Server Recovery modes
Bulk-Logged Recovery, 18??“20
changing, 20
Full Recovery, 17
overview, 16
Simple Recovery, 17??“18
SQL Server storage, 14??“16
striped backup, 32??“34
T-SQL backup, 21??“27
backup locations, 22??“24
comparison of backup locations, 24??“25
logical backup devices, 25??“27
media sets/backup sets, 27
naming conventions, 21
overview, 21
DATABASE command, 25
database console command (DBCC), 64
Database Maintenance Plan Wizard, 156
database mirroring, 11, 143, 269, 274, 285
clustering and, 275
improvements to, 326??“327
log shipping and, 275??“276
database mirroring feature
architecture of, 206
client connections with SNAC, 204??“206
connections, 201
endpoints, 201??“202
message queuing, 203??“204
mirror databases, 198??“199
overview, 196
ports, 201??“202
nINDEX 331
principal databases, 197??“198
witness servers, 200
configuring, 211??“223
disaster categories, 225??“226
modes, 206??“211
High Availability, 209??“211
High Performance, 206??“207
High Protection, 207??“209
overview, 206
selecting, 223??“225
overview, 195
database snapshots, 11, 229??“242, 269
architecture of, 229??“231
clustering and, 275
creating, 231??“233
disaster scenarios and, 240??“241
with environmental errors, 241
five disaster categories, 240
with hardware errors, 241
managing, 234??“238
linking to databases, 237??“238
naming conventions, 236??“237
with media failures, 241
overview, 229
with process errors, 241
restoring, 233??“234
with user errors, 241
uses for, 238??“240
creating reporting interface to mirrored
database, 240
dealing with process errors, 238
dealing with user errors, 239
leveraging snapshots in development,
240
point-in-time reporting, 239
restoring, 240
database states, identifying, 165
DatabaseBackupLSN field, 49
databases
linking database snapshots to, 237??“238
mirror, 198??“199
principal, 197??“198
size limitations, 148
standby, 146
multiple, 145
recovering, 165??“166
data-protection requirements, 100
DBA (database administration), 4, 283
DBCC (database console command), 64
DBCC CHECKDB command, 64
DBName_SS naming convention, 232
DDL (Data Definition Language), 327
DDL triggers, 328
default filegroups, 80??“81, 97
DEFAULT property, 81, 90
defaults, 280
DELETE clause, 193
DELETE command, 44
DELETE FROM Order command, 44
DELETE FROM TABLE command, 238
DELETE statement, 8, 15, 45, 233
dependent items, copying, 166
DES (Data Encryption Standard), 202
design, 112
DeviceType field, 49
differential backups, 29, 149, 321
creating file-specific, 88
restoring, 89??“90
in Bulk-Logged Recovery mode, 59??“60
in Full Recovery mode, 59??“60
in Simple Recovery mode, 59
Digital Linear Tape (DLT), 257
disaster categories, 38??“39, 72, 225??“226
backup locations, 38??“39
backup methods, 39
configuring log shipping and, 171??“172
hardware, 266??“267
overview, 38
recovery modes, 38
disaster drills, 278
disaster recovery, 3, 12
defined, 1??“2
disaster categories, 5??“10
environmental, 6
hardware, 6??“7
media, 7
overview, 5??“6
predictability, probability, and impact,
9??“10
process, 7??“8
user, 8??“9
overview, 1
relationship to high availability and
business continuity, 3??“5
technical perspective, 10??“11
disaster recovery planning, 269??“319
complementary technologies, 274??“276
clustering and database mirroring, 275
clustering and database snapshots, 275
clustering and log shipping, 275
database mirroring and log shipping,
276
defining mitigation plans, 274
developing response plans, 273??“274
documentation for, 276??“277
guiding principles, 270
identifying risk, 271??“273
overview, 269??“270, 293??“294
personality archetypes, 294??“304
doomsayers, 296??“297
holists, 301??“302
information hoarders, 298??“300
nINDEX 332
isolationists, 297??“298
overview, 294
pacifists, 302??“304
perfectionists, 295??“296
territorialists, 300??“301
roadblocks, 304??“318
banging the gong, 318
ineffective discovery process, 315
ineffective communication of risk, 316
issues with job role vs.
Pages:
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618