F

failover clustering

backup and recovery for, 606

definition of, 584

handling, 694–695

log shipping integrated with, 648

process for, 659–660

support for, by SQL Server edition, 15

upgrading, 72

failover, database mirroring

automatic, 549, 558–559, 563–565

forced, 549, 566–567

manual, 549, 565–566

preparing for, 579–583

failure of database, 591–593. See also backup and recovery

FAT file system, 374

fibers, compared to threads, 399

file associations, dropping, 46

file backup, 594

file differential backup, 594

file restore, 615

file systems, 374

filegroup restore, 615

filegroups, 385

filter, for tracing

creating, 420, 422

definition of, 418

Firewall, Windows, modifying for SSIS, 153–154

Flight Recorder for SSAS trace files, 200–201

float data type, 10

fn_trace_geteventinfo function, 423

fn_trace_getfilterinfo function, 423

fn_trace_getinfo function, 423

fn_trace_gettable function, 424

forced failover, database mirroring, 549, 566–567

fragmentation

of disks, 375

of indexes, 475–476

full backup, 593

full database restore, 614–615

full differential backup, 594

full recovery model, 596, 597, 598

full text indexes, 482

full-text catalog, upgrading, 66

full-text file backup, 602

full-text filegroup backup, 602

full-text restore, 617