Index_B

B

Background services, optimizing server for, 211

Backing up a database

to a network drive, 268

through SQL Server tools, 263

to a Zip drive, 271

Backing up files and file groups, 273-274

BACKUP command, DIFFERENTIAL option, 272

BACKUP DATABASE command, 268-270, 274

Backup devices, 264-265

Backup files, 264-265, 268, 270

BACKUP LOG command, 272-273

Backup media set, attempting to overwrite, 267

Backup options, 267

Backup programs, third-party, 262-263

Backup and recovery strategy, planning, 262-263

Backup and restore performance, optimizing, 274-275

Backup scheduling options, 266

Backup Set Expiration option, 267

Backup settings, advanced, 266-268

Backups

changing default directory for, 265

with multiple backup files, 268   

setting default expirations for, 268

spreading over files or devices, 265

types of, 263-275

Backupset table, 274

Backward compatibility, 45

BDC (backup domain controller), 11

Benchmark environment, 53

Beta version, upgrading from, 21

Bidirectional replication, 428

Bidirectional replication model, 428

BigInt data type, 196, 225

Bigint field, 196

Black box, 162-163

blackbox.trc trace file, 162-163

Blank passwords, auditing for, 74

Boost SQL Server Priority on Windows option, 31

boot.ini file

/pae switch in, 339

/3GB switch in, 339

Boyle, Neil, 232

BUILTIN Administrators account, 77-78

Bulk Copy Task, 123

Bulk Insert Task, 126

Bulk-Logged recovery model, 272, 277-278, 341

Business needs, high availability driven by, 344