Index_F

F

Failback tab (resource group properties), 411-412

Failed Login option, 71

Failed state (resource), 398

Failover, 372-374, 398, 411

Failover clustering, 347, 371-380, 402-403

high price of, 345

transaction replication for, 346

Failover Clustering screen, 402-403

Failover of a resource group, 398, 411

Fail-safe operator, 101

Fans, need for redundant, 346

FAT vs. NTFS file systems, 14, 210

Fault tolerance, 13

Federated servers, explained, 325

File groups in a database

backing up, 273-274

listing, 471

File permissions, 82

File and Printer Sharing, clustering and, 407

File size and creation date, viewing, 490-491

File systems, FAT vs. NTFS, 14, 210

FILEGROUP parameter (BACKUP DATABASE), 274

Files

backing up, 263, 273-274

checking for existence of, 181-182

copying, 295

determining existence of in a directory, 490

finding all details about, 183

Files on the server, listing all, 459

FileSystem object, 81, 203

Filtering mechanisms, 443

Filters, applying to a publication, 443-444

Filters (application layer), to remove malicious code, 90

Filters tab (Trace Properties screen), 256-257

Finding objects, 170

Firewalls, clustering and, 378-379, 407

Fixed database roles, 64-66

Fixed drives and space available, listing, 490

Fixed roles, rights of, 65

Fixed server roles, 64

Flushing the procedure cache, 236

Forecasting growth, 160-161

Foreign data source, import/export from, 126

Foreign keys in a database, list of, 471

Format Partition screen, 385

Four-part server name, 316-318

Four-server replication topology, 431

Fragmentation in tables, viewing, 248

Full database backups

in Enterprise Manager, 264-268

in T-SQL, 268-271

Full database restores, 282-287

Full recovery model, 272, 277, 341

Full-text catalogs in a database, list of, 472

Fully qualified filenames, 179