See T-SQL
Transaction Log Backup Settings screen, 159
transaction log file, 76
Transaction Log Shipping Status report, 171
transaction logs, 14, 97
.trn extension, 28
nINDEX 340
troubleshooting, 113
T-SQL (Transact SQL), 234. See also T-SQL
backup
RESTORE command, 47??“70
data pages, 64??“65
differential backups, 59??“60
full backups, 53??“59
information contained in MSDB, 52??“53
information in backup file, 47??“52
mirroring backups, 62
restoring to specific point in time, 60??“62
striping backups, 63
system databases, 65??“70
verifying backups, 63??“64
scripts, 113, 234
T-SQL (Transact SQL) backup, 21??“27
backup locations, 22??“24
local disks, 22
mapped network drive letters, 22??“23
overview, 22
tape, 23??“24
UNC share, 23
comparison of locations, 24??“25
logical backup devices, 25??“27
advantages of, 26
dropping, 26
managing, 26??“27
overview, 25
media sets/backup sets, 27
naming conventions, 21
overview, 21
two-node clustering, 181, 186
Type field, 50
nU
UNC (UniformNaming Convention) path, 23
uncoupled systems, 144
UnicodeComparisonStyle field, 49
UnicodeLocaleID field, 49
Uniform Naming Convention (UNC) path, 23
Uninterruptible Power Supply (UPS), 264,
265, 284
UNLOAD|NOUNLOAD option, 47
UPDATE PRODUCT SET PRICE=1*1.
Pages:
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627