database_mirroring_endpoints table, 208
sys.databases, 237
sysjobschedules schedule, 114
SYS.MASTER_FILES table, 68
sys.sysdatabases, 237
system databases, 65??“70
distribution, 68
master, 65??“66
model, 67
MSDB, 66??“67
ReportServer, 70
ReportServerTempDB, 70
resource, 69??“70
tempdb, 68
nT
tables, 135??“136
isolating specific, 86
overview, 135
partitioning, 86
potential approach, 135
requirements, 135
risks, 135??“136
separating read/write and read-only, 85
tail-log, 280
tail-log backups, 322
tape storage, 23??“24, 243, 257??“258
technical constraints, for BRPs, 113
cost, 111??“113
hardware capabilities, 109??“110
overview, 108??“109
personnel availability, 110
portability, 110??“111
tempdb databases, restoring, 68
TEMPDEV file, 68
temperature control, 281
template, general, for base BRPs, 124??“125
TEMPLOG file, 68
territorialists, 300??“301
dealing with, 301
overview, 300
problems created by, 300??“301
what they value, 300
testing, 112, 137
TEXT binary data type, 324??“325
TEXT type, 81
third-party backup products, 111
tightly coupled systems, 144
training, 111, 283
Transact SQL.
Pages:
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626