Index

A

Account Retry Attempts, 326

Account Retry Delay (Seconds), 326

Active node, 34, 35

ActiveX scripts, 342

Address windows extensions (AWE), 115

AdventureWorks2008R2 database, 11, 281

Agents, 45

ALTER DATABASE command, 4

AlwaysOn, 4

advantages and disadvantages, 55

Availability Groups, 52

implementation, 5355

key terms, 52

secondary replicas, 52

synchronous and asynchronous mode, 53

Analysis Services tasks, 342

Articles, 45

@attach_query_result_as_file, 330

Availability Group, 52

Availability replica, 52

B

Backupfile, 279

Backupfilegroup, 279

Backupmediafamily, 279

Backupmediaset, 279

Backup/restore migration method, 94

Backups, 257

architecture, 258259

compression, 266

percentage per backup, 266267

Resource Governor, 266

sp_configure ...

Get Pro SQL Server 2012 Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.