ldf extension, 14, 76
leveraging snapshots in development, 240
licensing, 277
Linear Tape-Open (LTO), 257
linking database snapshots to databases,
237??“238
LOB (Large object) operations, 19
???local??™ clause, 168
local disks, 22, 24
locally attached storage, 246??“248
ATA versus SCSI, 247
overview, 246??“247
USB and FireWire connections, 248
location boundaries, 145
log backups, 28, 149, 165, 321
log cache tuning, 327
log compression, 327
log marks, 60, 61??“62
Log Sequence Number (LSN), 28, 61
log shipping, 11, 141??“173, 274
architecture, 148??“150
basic, 149??“150
multiple standby servers, 150
benefits of, 143??“146
low resource overhead, 145
multiple standby databases, 145
no location boundaries, 145
nINDEX 335
standby databases accessibility, 146
stateless system, 143??“144
clustering and, 275
configuring, 151??“172
disaster categories and, 171??“172
failback to primary server, 169??“170
failover, 164??“169
manual, 152??“155
monitoring environment, 170??“171
overview, 151??“152
in SQL Server 2000, 155??“156, 163
database mirroring and, 276
drawbacks of, 146??“148
data loss, 146
database size limitations, 148
failback, 148
failover, 148
network latency, 146
overview, 141
versus replication, 142??“143
logical backup devices, 25??“27
advantages of, 26
dropping, 26
managing, 26??“27
overview, 25
logical dependencies, 188
logical failover, 189??“190
logical unit numbers (LUNs), 256
LogicalName field, 50
LogMarkAfterUpdate transaction, 61
loopback address, 222
loosely coupled systems, 144
low system downtime, 225
low user downtime, 225
LSN (Log Sequence Number), 28, 61
LTO (Linear Tape-Open), 257
LUNs (logical unit numbers), 256
nM
magnetic media, 244
maintenance, 113
manual log shipping, 152??“155
mapped network drive letters, 22??“23
master copy, 276
master databases, restoring, 65??“66
.
Pages:
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621