B

backup and recovery

archiving data, 623–624

backup execution

with Management Studio, 607–612

with T-SQL statements, 612

backup images, verifying, 599–600

backups of database

initial, after installation, 44

for SSAS databases, 194–197

types of, 593–595

data usage patterns, analyzing for, 604–605

disaster recovery planning, 624–625, 628–629

failure of database, causes of, 591–593

for high-availability solutions, 606

history tables for, 600–601

log shipping and, 628–629, 647

maintenance time window for, 605–606

managing backups, 612–613

performance of, 613–614

permissions for, 601

recovering database

definition of, 595

with Management Studio, 617–620

process for, 614–617

for system databases, 621–622

with T-SQL statements, 620–621

recovery models, 596–599

recovery plan, 602–606

restoring database, 595–596

for system databases, 601–602

BACKUP DATABASE statement, 600, 602, 612

BACKUP LOG statement, 612

Backupfile table, 600

Backupfilegroup table, 600

Backupmediafamily table, 600

Backupmediaset table, 600

Backupset table, 600

backward compatibility, 64–66

Baklini, Randy (HP), 706

Banyan VINES, 65

BEGIN DIALOG statement, 227–228

Benchmark Factory, Quests', 378

BI (Business Intelligence) DBA, 3

BI (Business Intelligence) features, 14–15. See also SSAS (SQL Server Analysis Services); SSIS (SQL Server Integration Services); SSRS (SQL Server Reporting Services)

BIDS (Business Intelligence Developer Studio)

executing packages with, 171

starting Import and Export Wizard from, 159

bigint data type, 10, 11

binary data type, 11

binary data types, list of, 11

bit data type, 10, 11

blocking, monitoring, 435

Books Online (BOL). See also publications

"DDL Event Groups for Use with Event Notifications" (Books Online topic), 433

"Dynamic Management Views and Functions" (Books Online topic), 434

"I/O Architecture" (Books Online topic), 379

"SQL Trace Terminology" (Books Online topic), 418

"Using SQL Server Profiler" (Books Online topic), 425

boot.ini file, memory configuration settings in, 345, 357–359

broken log chain, 594

BUILTIN\Administrators login, 301–302

bulk transaction-log backup, 595

bulkadmin role, 297

bulk-logged recovery model, 596–597, 598

Burgess, Eric (PSS), 47

burning in SQL Server, 38–39

Business Intelligence (BI) DBA, 3

Business Intelligence (BI) features, 14–15. See also SSAS (SQL Server Analysis Services); SSIS (SQL Server Integration Services); SSRS (SQL Server Reporting Services)

Business Intelligence Developer Studio (BIDS)

executing packages with, 171

starting Import and Export Wizard from, 159