See logical backup devices
backup file, 47??“52
RESTORE FILELISTONLY command, 50
RESTORE HEADERONLY command,
47??“50
RESTORE LABELONLY command, 51
RESTORE VERIFYONLY command, 51??“52
backup file sizes, 29??“30
backup locations, 38??“39
BACKUP LOG statement, 32, 89, 324
backup methods, 39
Backup Settings button, 158
BACKUP statement, 45, 48
BACKUP VERIFYONLY command, 63
BackupFinishDate field, 49
backup/recovery plans (BRPs), 99??“139, 277
base BRPs, 124??“137
fast restore, 128??“131
flexible portability, 133??“134
full-text catalogs, 136??“137
general template for, 124??“125
minimal data loss, 131??“133
overview, 124
short backup window, 125??“128
tables, 135??“136
business constraints for, 102??“108
cost, 105
data loss, 104??“105
overview, 102??“103
time to back up, 103??“104
time to restore, 104
caveats and recommendations, 139
components of, 100??“102
enhancing basic scenarios, 138
initial and periodic testing, 137
Index
329
overview, 99??“100
SQL Agent, 113??“123
agent proxies, 117??“122
alerts, 122??“123
job schedules, 114
job step tokens, 116??“117
jobs and job steps, 114??“116
overview, 113
technical constraints for, 113
cost, 111??“113
hardware capabilities, 109??“110
overview, 108??“109
personnel availability, 110
portability, 110??“111
backup/restore, improvements to, 321??“326
FILESTREAM data, 324??“326
native backup compression, 322??“324
tail-log backups, 322
Backup/restore planning, 259
backups
cold, 37
copy-only, 36
database, 13??“41
differential, 29
full, 28
full-text, 37
log, 28
mirroring, 35??“36, 62
securing, 32
striped, 32??“34
striping, 63
structure, 37
T-SQL, 21??“27
verifying, 63??“64
BackupStartDate field, 49
BackupType field, 49
.
Pages:
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616