Index_L

L

Lamport, Leslie, 105

large tables, 442

latency, log shipping, 279

layers , monitoring in, 695

leadership, DBA team, 32

Linear Tape-Open (LTO), 43839, 500

LIST DISK command, 197

LIST VOLUME command, 196

load balancing, 5860, 67

load tests, 4445, 516

Local Backups , 501

Local Distributor, 356

local network accounts, 291

local system accounts, 291

locks

data center security, 25

locking hints, 9293

logical disk performance counters, 93

logical disks, 86

logical failures, 562

logical fragmentation, 65455

logical unit, LUNs, 8586

logins

DTS packages for transferring, 30910

levels of, 287

multiple databases and, 280

replication and, 348

secure transfer of, 292

SQL Server 2000 upgrade and, 59091, 600601

synchronizing following recovery, 576

transferring between instances, 68289

transferring to standby, 681

Log Reader Agent, 353, 355

logs

cluster size and, 18283

failover clusters, 263

monitoring, 704, 722

Network Load Balancing Manager and, 2067

OLTP systems and, 113

tempdb system database and, 124

UNC paths and, 713

log sequence number (LSN), 283

Log Settings dialog box, 2067

log shipping, 273343

advantages of, 81

applications and, 28890

authentication, 293

availability technology and, 7880

built-in, 29697

business considerations, 27677

clients , 69

custom, 29697, 33940

database backups and, 29394

database synchronization, 517

data captured by, 286

defragmenting VLDBs, 65556

disk capacity and, 28081

DTS packages, 287

failover clusters compared with, 7778

files and filegroups, 29596

full-text searches, 28183

latency, 279

logins, 287

merge replication, 37475

multiple databases, 280

network bandwidth, 28586

overview of, 6768, 27375, 37273

recovery models for, 28385

role changes, 290, 37577

secondary, 522

security, 29193

server capacity and configuration, 27980

service packs and, 295

split-mirror backups and, 456

SQL Server 7.0 to SQL Server 2000, 34043

SQL Server 7.0 upgrade and, 619

SQL service packs and, 63233

stored procedures, 286

technical issues, 27779

transactional replication and, 7477, 37374

transactions, 6869

uses of, 273275

log shipping, administering, 31939

Log Shipping Monitor, 32933

monitoring, 32123

parameters, changing, 32428

primary, switching back to original, 339

removing, 31920

role changes, 33538

secondary, adding, 33335

secondary, deleting, 320

log shipping, configuring, 297319

components , 29899

Database Maintenance Plan Wizard, 304

DTS packages for transferring logins, 30910

jobs, 3012

log shipping monitor, 302

overview of, 29798

parameters, 3058

post-configuration tasks , 309

restoring initial backup on secondary, 3034

role changes, 31116

stored procedures, 299301

syslogin backup and, 31011

troubleshooting, 31819

verifying configuration, 317

Log Shipping Monitor, 6768

monitoring log shipping with, 32122

moving to another SQL Server, 32933

overview of, 302

tweaking log shipping configuration, 32728

verifying log shipping configuration, 317

log space, 722

log_shipping_monitor table, 33132

LooksAlive process, 56, 6465

low-level failures, 562

LRQ_Trace_Start, 71821

LSN (log sequence number), 283

restoring transaction logs and, 494

LTO (Linear Tape-Open), 43839, 500

LUNs, 8586