ldf file, 69
mssqlsystemresource.mdf file, 69
MTTF (mean time to failure), 251
multiplexing, 32
nN
N+1 formula, 186
NAME option, 232
NAME property, 27
name resolution, 262??“263
naming conventions, 241
database snapshots, 236??“237
four guideline questions, 236
T-SQL backup, 21
NAS (network-attached storage), 177,
254??“255, 258
native backup compression, 322??“324
natural disasters, 6
.ndf files, 14, 15, 76, 126, 231
net send command, 122
network cards, 179
network failure, 7
network latency, 146
network-attached storage (NAS), 177,
254??“255, 258
networks, 179, 260??“264
authentication, 263??“264
latency versus bandwidth, 261??“262
nINDEX 336
name resolution, 262??“263
routing, 263
NO RECOVERY clause, 161
NO RECOVERY state, 322
nonclustered indexes, 85
NORECOVERY clause, 53
NORECOVERY statement, 89
NOUNLOAD|UNLOAD command, 23
NT LAN Manager (NTLM), 263
NTEXT binary data type, 325
NTEXT type, 81
NTLM (NT LAN Manager), 263
nO
objects, assigning to filegroups, 81??“84
creating objects in, 81??“83
moving objects to, 83??“84
OLTP (online transaction processing)
database, 85
ON clause, 81, 97
online disk storage, 244??“257
block size versus stripe size, 245??“246
locally attached, 246??“248
ATA versus SCSI, 247
overview, 246??“247
USB and FireWire connections, 248
overview, 244??“245
RAID configurations, 248??“254
overview, 248
RAID 0, 248??“249
RAID 0+1, 252??“253
RAID 1, 249
RAID 1+0, 252??“253
RAID 5, 250
RAID 5+1, 253??“254
RAID 6, 251
vendor-specific, 254
remote, 254??“256
NAS, 254??“255
overview, 254
SAN, 255??“256
tape, 257
ONLINE mode, 71
online transaction processing (OLTP)
database, 85
OPENROWSET command, 19
Order Detail table, 135
Order table, 92, 135
Order_FG filegroup, 135
OrderHistory table, 92
OutgoingCredential credential, 120
OUTPUT clauses, 328
nP
pacifists, 302??“304
dealing with, 303??“304
overview, 302??“303
problems created by, 303
what they value, 303
Page Free Space (PFS), 64
PARTIAL clause, 94
PARTIAL keyword, 93
partial restore, 94
PASSWORD property, 32
peer-to-peer model, 142
perceived downtime, 128
perfectionists, 295??“296
periodic testing, 137
persistence, 304
personality archetypes, 294??“304
doomsayers, 296??“297
holists, 301??“302
information hoarders, 298??“300
isolationists, 297??“298
overview, 294
pacifists, 302??“304
perfectionists, 295??“296
territorialists, 300??“301
personality conflicts, 294
personnel availability, 110
PFS (Page Free Space), 64
physical failover, 188??“189
PhysicalName field, 50
planning, 269
point-in-time reporting, 239
point-in-time view, 229
points in time, restoring to, 60??“62
creating log marks, 61??“62
jumping to LSN number, 61
specifying time, 60??“61
port number, 201
portability, flexible, 133??“134
overview, 133
potential approach, 133??“134
requirements, 133
risks, 134
ports, 201??“202
Position field, 49
POST (power-on self-test), 7
power, 264??“265
power-on self-test (POST), 7
predictability of events, 9??“10
primary data files, 14, 76
primary database, 196
PRIMARY filegroup, 77, 90, 94, 97, 126, 135
principal databases, 197??“198
principle proxies, 119
priority list, 271
nINDEX 337
probability of occurrence, 9??“10
problematic environment, 318
process disasters, 278??“281, 287??“289
process errors, 7??“8, 193, 238
process log shipping, 172
Product Support Services (PSS), 37
proprietary storage structure, 178
PSS (Product Support Services), 37
nQ
quorum, 178??“179
nR
RAID, 40, 247??“253
raising awareness, 306
READ_WRITE_FILEGROUPS keyword, 92
read-only tables, 85
read/write tables, 85
Recover Interval instance setting, 15
recovery
availability during, 46??“47
versus restoring, 44??“45
RECOVERY clause, 45, 61, 73
Recovery column, 52
RECOVERY INTERVAL setting, 46
recovery modes, 38
redundancy, 268
registry update, 167
release-to-manufacturing (RTM), 204, 321
remote standby database, 276
remote storage, 254??“256
NAS, 254??“255
SAN, 255??“256
Replace column, in MSDB restorehistory
table, 52
REPLACE option, 55
replacement hardware, 193
replication method, 172
replication, versus log shipping, 142??“143
reporting interfaces, 240
ReportServer databases, restoring, 70
ReportServerTempDB databases, restoring,
70
resource databases, restoring, 69??“70
resource dependencies, 188
resources, cluster, 177??“178
Response column, 273
response plans, 273??“274
response technologies, 11
Restart column, in MSDB restorehistory
table, 52
restore categories, 72
RESTORE command, 43??“70
backup file, 47??“52
RESTORE FILELISTONLY command, 50
RESTORE HEADERONLY command,
47??“50
RESTORE LABELONLY command, 51
RESTORE VERIFYONLY command,
51??“52
data pages, 64??“65
differential backups, 59??“60
full backups, 53??“59
Bulk-Logged Recovery mode, 56
fast file initialization, 58??“59
Full Recovery mode, 55??“56
restoring to new location, 56??“58
Simple Recovery mode, 53??“54
mirroring backups, 62
MSDB, 52??“53
restoring to specific point in time, 60??“62
creating log marks, 61??“62
jumping to LSN number, 61
specifying time, 60??“61
striping backups, 63
system databases, 65??“70
distribution, 68
master, 65??“66
model, 67
MSDB, 66??“67
ReportServer, 70
ReportServerTempDB, 70
resource, 69??“70
tempdb, 68
verifying backups, 63??“64
RESTORE DATABASE command, 60, 93, 326
RESTORE FILELISTONLY command, 47, 50
RESTORE HEADERONLY command, 47??“50,
61
RESTORE LABELONLY command, 47, 51
RESTORE LOG command, 326
Restore Options dialog box, 161
RESTORE statement, 45, 48
RESTORE VERIFYONLY command, 47, 51??“52,
63
Restore_Database_Name column, 52
Restore_Date column, 52
Restore_Type column, 52
restorefile table, 52
restorefilegroup table, 52
restorehistory table, 52
restoring.
Pages:
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623