Index_T

T

tables

database schema, 349

filegroup backups , 442

log shipping, 300301

system tables, 605

user error and, 38283

tail of the log, recovery models, 407

tapes, backup

LTO (Linear Tape-Open), 43839

tips for, 499, 501

working with, 45354

TCP/IP (Transmission Control Protocol/Internet Protocol)

advanced settings, 174

failover clusters and, 24849

Network Load Balancing and, 5860

technical planning phase, SQL Server 2000 upgrade, 593606

administration, 6023

application compatibility, 595

choices, 517518

chargeback , 603

collations, 6045

disk subsystem, 595

high availability, 601

logins, 600601

memory, 59698

migrating objects, 602

networking, 599

processor, 59698

questions, 58693

replication, 6012

security, 600601

single instance vs. multiple instances, 59394

sort orders, 6045

system databases, 6034

technology, 5182

availability, 7880, 51718

backup and restore, 7172, 380

budgets and, 73

decision process, 7274

disks, 103

evaluating, 7481

failover clusters, 6167

focusing on requirements first, 515

geographically dispersed clusters, 6061

instance support, 62

log shipping, 6769

Microsoft.com case study, 528

Network Load Balancing, 5860

overview of, 5152

replication, 6971

validating, 611

Windows Clustering. see Windows Clustering

telephones, data center, 25

tempdb database

determining size of, 88, 12829

not necessary to backup, 561

placement of, 124

restoring, 566

temporary tables in, 604

upgrade and, 59293

temperature control, 21, 109

Terminal Services, 147

testing

disaster recovery, 553, 55657

environment for, 3638

failover clusters, 24144

hotfixes, 625

implementation, 4445

load tests, 516

monitoring, 692

overview of, 4041

pilot tests, 611

service packs , 625

test platform, 581, 60810

upgrades, 60710

Windows Server 2003 enhancements, 156

text

database schema and, 34950

disk space and, 89

filegroup backups, 442

third-party hardware, 45455

third-party hosting, 2728

third-party software, 22021, 509

thresholds, failover, 23841

time, barriers to availability, 18

time-based backups, 467

timeline, disaster recovery, 55960

timestamp columns , database schema, 35152

Titanic , 56, 9

torn pages, 120

trace flags, 100101, 395

traces, 71821

training, DBA team, 31

Transactionally current, 7879

transaction log backups

automating, 46769

executing with Transact -SQL, 46162

file/filegroup backup strategy and, 431

full database backups and, 42021

full database-based backup and, 435

how they work, 423

overview of, 422

recovery models and, 42324

sequence to, 393

transaction logs

backups and, 29394

continuity of, 39294, 397

database creation and, 4014

keeping current, 279

log shipping and, 27778

managing, 39899

optimizing performance, 39091

when filled, 39497

write-ahead , 38690

transactional replication

advantages of, 81

availability technology comparison table, 7880

columns and, 349

consistency of, 70

disaster recovery, 37172

DTS (Data Transformation Services) and, 369

log shipping and, 7477, 37374

overview of, 70

primary keys and, 348

rows and, 349

Subscribers and, 367

sync with backup option, 366

when to use, 34748

transactions

atomic, 288

avoid long-running, 398

batching , 398

failover clusters and, 66

keeping current, 279

log shipping, 6869

lost, 27677

per hour , 276

Transact-SQL backups

differential database backup, 462

file-based backup, 46265

full database-based backup, 46061

options for performing backups, 44445

removing backup devices, 446

transaction log backup, 46162

Transmission Control Protocol/Internet Protocol. See TCP/IP (Transmission Control Protocol/Internet Protocol)

troubleshooting

failover clusters. see failover clusters, troubleshooting

guides, 52829

log shipping, 31819

Sysperfinfo, 718