Best Practices 65
Symbols
% Disk Time counter, PDF:789
% Processor Time counter, PDF:789 64-bit computing
new features, PDF:542 SSIS, 186-187
A
a apply option (Rskeymgmt utility), 123
a authmethod option (RSConfig utility), 122
access
account lockout policies, 481 Books Online, PDF:573 Business Intelligence
Development Studio, PDF:577 Configuration Manager, PDF:582 Database Engine Tuning Advisor,
PDF:586
full-text catalog properties, 375-376
full-text index population status, 371
groups, 476 instances, 155-156
Management Studio, PDF:575 Notification Services,
156-157, 172
Operations Manager 2007, PDF:831-PDF:832 Query Editor, PDF:590 Report Builder, PDF:593 Reporting Services Configuration
Manager tool, PDF:584 roles, 475-478
access groups, 476 database-level, 477-478 role groups, 476 server-level, 476-477
Server Profiler, PDF:585 Surface Area Configuration tool,
PDF:583 accounts
Database Mail, PDF:758 full-text service, 384-385 lockout policies, 480 Notification Services database access,
granting, 172 defining, 159-161 identifying, 154-155 NSRulesEvaluator, 159 Operations Manager 2007
service/security, PDF:831-PDF:832 remote
clusters, PDF:665
Service Pack 2 installation, PDF:676
SA, 439-441 service
choosing, 458 clusters, PDF:666
database mirroring, PDF:705 failover clustering, PDF:681 hardening, 455-458 modifying, 458-460 Operations Manager 2007,
PDF:831-PDF:832 OpsMgr, PDF:781 types, 457
SQL.NSInventory Windows domain user, 160-161 active/active clustering,
PDF:652-PDF:655 Active Directory role-based
security, 476 active nodes, PDF:651 Active Sessions counter,
PDF:796-PDF:797 ActiveX Script Task, 390
838 access
Activity Monitor
health check data gathering, 268 process monitoring,
PDF:813-PDF:815
ADFs (application definition files), 151, 164-170
administration indexes, 328
clustered, creating, 333-334 disabling, 335-336
enabling, 336-337 maintenance, 337-338 nonclustered, creating, 335 rebuilding, 337
Transact-SQL syntax, 328-332 log shipping, PDF:728
Copy Files job, creating, PDF:734-PDF:735 database recovery model,
PDF:729-PDF:730 implementing,
PDF:730-PDF:731 monitor servers, adding,
PDF:737-PDF:738 restoration options, PDF:736-PDF:737 secondary databases,
PDF:733-PDF:734 storage locations,
PDF:728-PDF:729 transaction log backup
settings, PDF:731-PDF:733 Notification Services, 157-159
accounts, defining, 159-161 database access,
granting, 172
creating instances, 161-162 enabling instances, 170 Inventory Tracker ADF file,
164-170
Inventory Tracker ICF file, 162-164
nonhosted event providers, configuring, 172-174 nscontrol utility, 179-180
registering instances, 170-171 starting instances, 174 subscribers/subscriptions,
adding, 175-177 subscription data/
notifications, viewing, 177-178
updating instances, 178-179 replication. See replication security, 487
SSIS packages, 195-197 creating, 187-189 deleting, 195
importing/exporting, 190-191 reports, 194
running, 191-193 scheduling, 193-194 stopping, 195 storing, 189 viewing, 194 SSRS
command-line utilities, 121 Management Studio, 117-119 Report Manager, 119-120 rs command-line utility,
124-126
RSConfig command-line utility, 122-123
Rskeymgmt command-line utility, 123-124
ADO Connection Manager, 395 ADO.NET Connection Manager, 395 Advanced Settings page (server
prop-erties), 27-28
AdventureWorks database alerts, PDF:761 attaching, 73-74,
PDF:827-PDF:828 backups, PDF:606-PDF:607,
PDF:630-PDF:631
differential, PDF:607-PDF:608, PDF:618-PDF:619
full, PDF:615-PDF:618 transaction log,
PDF:619-PDF:621
configuring, PDF:827 Documents Catalog,
deleting, 378
downloading, 73, PDF:827 finding, 72
full-text catalogs, 359-362 full-text filegroups, defining,
357-359
historical data, deleting, 296 indexes, 293-294
installing, 73 integrity check, 291 logins, adding, 495 mirrored backups, PDF:614 publications
configuring, 224-225, 228-229 peer-to-peer transactional
replication, 236-238 shrinking, 292
snapshot, PDF:642-643 statistics, updating, 296 subscriptions, configuring,
229-233
tail-log backup, PDF:631-PDF:632 Test Schema, 498
transaction log tail-log backup, PDF:610-PDF:612
transaction log truncate backup, PDF:609-PDF:610
Agent alerts, 63 distribution, 211 error logs, PDF:763 jobs, 61-63
creating, 61-62 enabling/disabling, 62 history, 63
monitoring, PDF:753-PDF:755, PDF:771
running, 297 launching, 311 log reader, 211 merge, 212 operators, 63
OpsMgr, PDF:768 deploying, PDF:775 installing, PDF:783-PDF:784 security, PDF:780
properties, 59-61 proxy accounts, 63 queue reader, 212
replication, 211-212, PDF:567 snapshot, 211
Agent Properties dialog box advanced page, 60 alerts, 60
connections, 60 general page, 59 history, 61 jobs, 60
Aggregate Transformation, 393 alerts
Agent, 60, 63
defining, PDF:760-PDF:761 generating, PDF:767 OpsMgr, PDF:766 responses, PDF:761 AllItems table, 333
All subscriptions tab (Replication Monitor tool), 252
ALTER ANY permission, PDF:547 ALTER ENDPOINT statement, 502 ALTER FULLTEXT CATALOG
command, 356 ALTER FULLTEXT INDEX
command, 356 ALTER FULLTEXT INDEX
statement, 373
ALTER INDEX statement, 330-332 ALTER LOGIN statement, 483 ALTER permission, PDF:547 ALTER ROLE statement, 485 ALTER SCHEMA statement, 486 ALTER USER statement, 484 Analysis Server Properties dialog
box, 86
840 Agent
Analysis Services (SSAS), PDF:551 AdventureWorks DW sample
database attaching, 73-74 downloading, 73 finding, 72 installing, 73 architecture, 69-70
backing up, 90, PDF:637-PDF:638 Connection Manager, 395 cubes, PDF:554
database deployment, 74 Analysis Services Deployment
Wizard, 75-78 Business Intelligence
Developer Studio, 78-79 SSIS, 80
Synchronize Database Wizard, 80
data sources, PDF:553-PDF:554 Deployment Wizard, 75-78
Select Processing Options screen, 78
Specify Configuration Properties screen, 77 Specify Options for Partitions
and Roles screen, 76 Specify Source Analysis
Services Database screen, 76 Execute DDL Task, 390 failover clustering installation,
PDF:668-PDF:671
full multidimensional databases, processing, 81-85
informational database reports, creating, 91
managing, 91
mining structures/modeling, PDF:555
new features, 71-72 objects
processing, 81 scripting, 91
OLAP storage models, 87-90
performance, 95-96, PDF:799-PDF:800 Processing Task, 390 properties, configuring, 86 recovering databases,
PDF:639-PDF:640 restoring, 90 roles, PDF:556 security, 91, 503-504
administrator privileges, granting, 92
database permissions, 92-93 roles, creating, 93-94 server/client communications,
PDF:552-PDF:553 tasks, 390 terminology, 68-69 UDM, PDF:551-PDF:552 versions, 70-71 viewing, 91 analyzing
BI features, PDF:541
data during health checks, 274 BPA results, 277-281 SQLDIAG results, 274-276 SQLH2 results, 276-277 queries, PDF:815-PDF:817 workloads, PDF:807-PDF:808 antivirus software, reviewing,
273, 285
APIs (application programming interfaces), 152
applications
definition files (ADFs), 151, 164-170
programming interfaces (APIs), 152
roles, managing, 499-500 SQLLogShip.exe, PDF:744 troubleshooting/optimization
cursors, PDF:817 locking/deadlocks,
PDF:818-PDF:819 query analysis,
PDF:815-PDF:817
architecture
Analysis Services, 69-70 OpsMgr, PDF:767-PDF:769 archiving data, PDF:778 assemblies, PDF:545 asymmetric keys, 512
asynchronous database mirroring, PDF:695
Attach Database dialog box, 74 Attach Databases dialog box, 55 attaching
AdventureWorks database, 73-74, PDF:827-PDF:828
databases, 54-56 audit tracing servers, 22 Audit Transformation, 394 authentication, 436
failover clustering, PDF:667 Kerberos, PDF:687 logins
mixed mode, 488-489 SQL, 489-492 Windows, 492-495 modes
choosing, 437-438 configuring, 438-439 mixed mode, 437 servers, 20-21
Service Pack 2 installation, PDF:675
SQL, 489-492
Windows, 436, 492-495 Authentication Mode screen
(Microsoft SQL Server Installation Wizard), PDF:667
Authentication screen (Service Pack 2 Setup Wizard), PDF:675 authenticators, 519-521 autogrowth (database files), 42 automatic failover (database
mirroring), PDF:702-PDF:707 automating database backups,
PDF:621-PDF:628
Auto or Advanced dialog box, PDF:783
availability, PDF:539
Available Bytes counter, PDF:789 Avg. Disk Queue Length counter,
PDF:789
B
Back Up Database Task, 297-298, 419-420
Back Up Databases Across One or More Files option (Back Up Database Task), 297 backing up
Analysis Services, 90, PDF:637-PDF:638 business scope, PDF:600 Database Engine, PDF:605
automating with maintenance plan, PDF:621-PDF:625, PDF:628
copy-only backups, PDF:613 differential backups,
PDF:607-PDF:609, PDF:618-PDF:619 differential partial backups,
PDF:613
filegroup backups, PDF:612 full backups,
PDF:605-PDF:607, PDF:615-PDF:618 mirrored backups, PDF:614 partial backups,
PDF:612-PDF:613
storage architecture, PDF:601 system databases, PDF:614 transaction log backups,
PDF:609-PDF:612, PDF:619-PDF:621 databases, 56, 297-298
automating with maintenance plan, PDF:621-PDF:625, PDF:628
842 Auto or Advanced dialog box
differential backup example, PDF:618-PDF:619 full backup example,
PDF:615-PDF:618 settings, 25
system databases, PDF:614 transaction log backup
example, PDF:619-PDF:621 devices, creating, 33
full-text catalogs, 384, PDF:641 importance, PDF:598-PDF:599 keys, 521-522
log shipping, PDF:723 need for, PDF:599 new features, PDF:598 objective, PDF:599 OpsMgr, PDF:774-PDF:775 replication, 248-249 Reporting Services
configuration/data files, PDF:636-PDF:637
databases, PDF:633-PDF:635 encryption keys,
PDF:635-PDF:636 websites, PDF:635
SQLLogShip.exe option, PDF:744 SSIS packages, 199
storage locations, PDF:726 strategies, reviewing, 273,
283-284 tasks, 420
technical aspects, PDF:600 Backup Component option (Back Up
Database Task), 297 Backup Devices folder, 33
Backup Set Will Expire option (Back Up Database Task), 297
Backup Up To option (Back Up Database Task), 297
BACKUP/DUMP permission, PDF:548 Bcp command-line tool, PDF:587 Best Practice Analyzer. See BPA
BI (business intelligence), PDF:541-PDF:542
Development Studio, 69, PDF:576 accessing, PDF:577
Analysis Services database deployment, 78-79 layout, PDF:576
packages, debugging, 406 SSIS packages, running, 191 transformation types (data
flow), 392
BLOBs (Binary large objects), 197, PDF:801
block analysis, PDF:771 Books Online, PDF:572
accessing, PDF:573 downloading, PDF:574 filtering, PDF:573 b option (rs utility), 124 BPA (Best Practice Analyzer),
266, 454
core services information, collecting, 270-271 health check data gathering,
266-267
recommendations, 279 reports, 278
results, analyzing, 277-281 security recommendations,
280-281
vulnerability and recommendation report, 455
b-tree structures (indexes), 321 Buffer Cache Hit Ratio counter,
PDF:793
Buffer Memory counter, PDF:801 Buffers in Use counter, PDF:801 Buffers Spooled counter, PDF:801 BUILTIN/Administrators Windows
group, deleting, 463 Bulkadmin fixed server role
permission, PDF:550 Bulk Copy utility, 432
Bulk Insert Task, 390 bulk-logged recovery model
(databases), 45, PDF:602
business continuity plans, reviewing, 273, 283-284
business intelligence. See BI Bytes Total/sec counter, PDF:789
C
Cache Flushes/Sec counter, PDF:797 Cache Hits/Sec counter,
PDF:796-PDF:797 Cache Misses/Sec counter,
PDF:796-PDF:797 caching, 69, 88-90 capacity limits (OpsMgr),
PDF:778-PDF:779 capturing
counters, PDF:790-PDF:792 workloads, PDF:805-PDF:807 CAs (certificate authorities), 512 catalogs
database mirroring monitoring, PDF:717
full-text
backing up, PDF:641 creating, 355-361
creating with DDL, 361-362 DDL, reviewing, 355-357 deleting, 378
full-text indexes. See full-text indexes
modifying, 356 new features, 353 optimizing, 374 populating, 369-371 population status codes,
376-377
properties, 374-376 rebuilding, 374 recovering, PDF:641
restoring, 384
searches, 354-355, 378-384 service accounts, configuring,
384-385 tables/views, 375 c connection option (RSConfig
utility), 122
central publisher/multiple
subscribers model (replication), 213 central subscriber/multiple
publishers model (replication), 214 Certificate Export Wizard, 530 Certificate Services, installing,
PDF:828-PDF:830 certificates, 512
authorities (CAs), 512 client-initiated encryption,
531-532
configuring, 529-531 creating, 515 databases, 515 exporting, 530 importing, 529 provisioning, 527-529 self-signed, 526
server configuration, 529 third-party, 526-529
Change Autogrowth dialog box, 42 Change Free Space per Page
Percentage To option (rebuild index task), 294
Change Settings dialog box, 84 change tracking (full-text indexes),
365-366, 373-374
Character Map Transformation, 393 characteristics of indexes, 321-323 Check Database Integrity Task,
291, 419
Choose Server to Configure screen (Database Mirroring Wizard), PDF:703
choosing
authentication modes, 437-438 maintenance tasks, 301
844 catalogs
nodes, virtual servers, PDF:665 recovery models (databases),
45-46, PDF:603 service accounts, 458 clients
certificates, configuring, 530-531 connections/redirects,
PDF:712-PDF:713 encryption, 531-532 SSAS communication,
PDF:552-PDF:553 Cluster Administrator, PDF:650,
PDF:659
Cluster Group Selection screen (Microsoft SQL Server Installation Wizard), PDF:663
Cluster Node Configuration screen (Microsoft SQL Server Installation Wizard), PDF:665
clusters
active/active, PDF:652-PDF:655 creating, PDF:657-PDF:658 disk requirements, PDF:657 failover, PDF:647
adding nodes, PDF:680, PDF:689
alternatives, PDF:651-PDF:652 Cluster Administrator, PDF:650 cluster-aware components,
PDF:653
cluster resources, PDF:649 creating clusters,
PDF:657-PDF:658 database mirroring
combination, PDF:699 dependencies, PDF:649 disaster recovery, PDF:648 DNS registration, PDF:687 drives, sharing,
PDF:680-PDF:681 failback, PDF:649,
PDF:685-PDF:686 failover, PDF:649, PDF:685 group resources, PDF:649 groups, PDF:682, PDF:689
heartbeats, PDF:649 high-availability alternative
combinations, PDF:653-PDF:654 installing for Analysis
Services, PDF:668-PDF:671 installing for Database Engine,
PDF:660-PDF:668
instances, deleting, PDF:681 Kerberos authentication,
PDF:687
log shipping combination, PDF:727
majority node clusters, PDF:650
MSDTC installation, PDF:659 multiple-instance example,
PDF:654-PDF:655 objective, PDF:648 patch management,
PDF:672-PDF:680 pausing/resuming nodes,
PDF:688
preparing nodes, PDF:655 preferred owners,
PDF:683-PDF:685 prerequisites,
PDF:650-PDF:651
quorum-device clusters, PDF:650
quorum resources, PDF:649, PDF:682
renaming resources, PDF:689 replication combination, 218 resource status, PDF:682 second nodes, adding,
PDF:659
scalability, PDF:653 server load performance/
degradation, PDF:653 service accounts, managing,
PDF:681
shared storage, configuring, PDF:656
virtual servers, PDF:648
geographically dispersed, PDF:652
indexes, 319
characteristics, 323 creating, 333-334 design, 325 disabling, 335-336 enabling, 336 majority node, PDF:650 N+1, PDF:652
N+M, PDF:652
quorum-device, PDF:650 remote accounts, PDF:665 resources, PDF:649
second nodes, adding, PDF:659 service accounts, PDF:666 Code Editor tool. See Query
Editor
collation (databases), 43, PDF:667 Collation Settings screen (Microsoft
SQL Server Installation Wizard), PDF:667
columns (indexes) computed, 322-323 constraints, 322
nonclustered indexes, 323 uniqueifier, 325
command-line tools, PDF:587-PDF:588
Bcp, PDF:587 dta, PDF:587
dtexec, 202-204, PDF:587 dtutil, 205-206, PDF:588 log shipping management,
PDF:744-PDF:745 MSBuild, 175
nscontrol, 179-180, PDF:588 osql, PDF:588
profiler90, PDF:588 rs, PDF:588
rsconfig, 122-123, PDF:588 rskeymgmt, 123-124, PDF:588 sac, PDF:588
sqlagent90, PDF:588
sqlcmd, PDF:588 SQLdiag, PDF:588
health check data gathering, 264-265
performance information, collecting, 268-270 results, analyzing, 274-276 sqllogship Application, PDF:588 sqlmaint, PDF:588
sqlservr Application, PDF:588 sqlwb, PDF:588
SSRS administration, 121 rs, 124-126
RSConfig, 122-123 Rskeymgmt, 123-124 tablediff, PDF:588 commands
ALTER FULLTEXT CATALOG, 356 ALTER FULLTEXT INDEX, 356 CREATE FULLTEXT CATALOG, 355 CREATE FULLTEXT INDEX, 356 nscontrol utility, 179-180 Common Jobs tab (Replication
Monitor tool), 252 Compact Edition, PDF:570
compatibility levels (databases), 47 Complete the Wizard screen
(Database Mirroring Wizard), PDF:705
Components to Install screen (Microsoft SQL Server Installation Wizard), PDF:661
computed columns (indexes), 322-323
Computer and Device Management Wizard, PDF:783
Conditional Split Transformation, 394 configuration class tools, PDF:581
Configuration Manager, PDF:581-PDF:582
Reporting Services Configuration Manager, PDF:584-PDF:585 Surface Area Configuration tool,
PDF:583
846 command-line tools
configuration files (Reporting Services), PDF:636-PDF:637 Configuration Manager, PDF:581
accessing, PDF:582 certificates, configuring, 529 features, PDF:581
hardening with, 445-449 Protocols for MSSQLSERVER
properties, PDF:582 service accounts, modifying,
458-460 SSRS, 105-107 configuring
Analysis Services properties, 86 authentication modes, 438-439 certificates, 529-531
clusters, PDF:657-PDF:658, PDF:665
database encryption, 514 Database Mail, PDF:759 database mirroring
automatic failover, PDF:702-PDF:707 endpoints, PDF:707 high availability,
PDF:696-PDF:697, PDF:702-PDF:707 high performance,
PDF:696-PDF:697 high protection,
PDF:696-PDF:697 mirror server instances,
PDF:703
prerequisites, PDF:697, PDF:701-PDF:702 principal server instances,
PDF:703 security, PDF:703
service accounts, PDF:705 witness server instances,
PDF:705 destinations, 412-413 email settings, 114-117 execution account (SSRS), 117
failover clustering shared storage, PDF:656
full-text service accounts, 384-385
indexes
fill factors, 341-343 fragmentation, 339-341 full-text indexes, 365-366 index statistics, 339 options, 347-348
performance tuning, 344-346 rebuilding/reorganizing, 343 sorting indexes, 343 log shipping
database recovery model, PDF:729-PDF:730 storage locations,
PDF:728-PDF:729 My Reports (SSRS), 128-129 nonhosted event providers,
172-174
Notification services, 150, 179-180
OpsMgr, PDF:769 packages, 424-427
LOGFILE environment variable, creating, 425-426
Package Deployment utility, 427-428
peer-to-peer transactional replication, 234
distributors, 234-236 first node, 236-238 nodes, adding, 243-244 publications, enabling, 239 topology, 239-242 report execution
logging, 132-133 timeout, 131-132 report history, 129-131 Report Manager virtual
directory, 110
Report Server virtual directory, 109-110
security auditing, 461
servers
checking, 282-283 encryption, 524
shared data source credentials, 139-140
SharePoint integration, 113 SMTP servers, PDF:756-PDF:757 snapshot replication, 219
distributors, 220-224 publications, 224-229 subscriptions, 229-233 SSRS, 105
databases, 113 properties, 106 site server name, 127 transaction log backup settings,
PDF:731-PDF:733
virtual servers, PDF:662-PDF:663 Web service identity, 112-113 Windows service identity,
111-112 connections
Agent, 60
managers, PDF:562 packages, 395-396, 405 remote, 24
servers, 22-24 SSRS, 107-108 console logging, 198 constraints (column), 322 containers (packages), 390 context switching, PDF:550 control flow
adjusting, 410-411
color coordination steps, 408 drop table task, adding, 407-408 packages, 389-390
maintenance tasks, 421 walking through, 401-402 Control Flow tab (packages),
407-408
control flow tasks, PDF:562 CONTROL permission, PDF:548
controlled failovers, PDF:742-PDF:743
Copy Column Transformation, 393 Copy Database Wizard, 430-431 copying databases, 430-431 copy jobs
Copy File job, PDF:734-PDF:735 log shipping, PDF:724
copy option (SQLLogShip.exe), PDF:745
copy-only backups, PDF:613 core services information, collecting,
270-271 counters
Analysis Services Memory, PDF:799-PDF:800 performance
Analysis Services, PDF:799-PDF:800 Database Engine,
PDF:792-PDF:793 Integration Services,
PDF:800-PDF:802 MSRS 2005 Web Service,
PDF:796-PDF:797
MSRS 2005 Windows Service, PDF:797-PDF:798
Reporting Services, PDF:796-PDF:798 platform performance,
PDF:788-PDF:789
capturing, PDF:790-PDF:792 sample datasheet, PDF:791 SSIS packages, 197-198 viewing, PDF:790
Create a Backup File for Every Database option (Back Up Database Task), 298 Create command (nscontrol
utility), 180
CREATE ENDPOINT statement, 502 CREATE FULLTEXT CATALOG
command, 355
848 controlled failovers
CREATE FULLTEXT INDEX command, 356
CREATE INDEX statement, 328-330 CREATE LOGIN statement, 482 CREATE permission, PDF:548 Create Role dialog box, 94 CREATE SCHEMA statement, 486 CREATE statement, 485
CREATE USER statement, 484 credentials (shared data sources),
139-140
critical fixes, installing, 461 cross database ownership
chaining, 22
Cube properties dialog box, 89 cubes, PDF:554
cursors
application performance, PDF:817 database recovery options, 48 Customer Experience Improvement
Program, PDF:677
D
DAC (dedicated administrator connection), 472
daily tasks, maintenance, 312-313 Danish language support, 382 data
analyzing during health checks, 274
BPA results, 277-281 SQLDIAG results, 274-276 SQLH2 results, 276-277 archiving, PDF:778
Conversion Transformation, 393 flow
adjusting, 411-412 designer, 403
packages, 391-394, 403-405 tasks, 389, PDF:562
gathering for health checks, 263-264
Activity Monitor, 268 antivirus software,
reviewing, 273 backup strategies,
reviewing, 273 BPA tool, 266-267 business continuity plans,
reviewing, 273 core services, 270-271 Log File Viewer, 268 log shipping, 271-272 performance, 268-270 Profiler, 268
SQLDIAG tool, 264-265 SQLH2 tool, 266 transaction logs, reviewing, 272 management, new features,
PDF:539-PDF:540 mining
BI features, PDF:541 Model Training
Destination, 391 Query Task, 390
Query Transformation, 392 structures/modeling, PDF:555 preparation tasks, 389
Reporting Services files, backing up, PDF:636-PDF:637 sources
shared, 139-140 SSAS, PDF:553-PDF:554 SSRS, 103-104, 143-144 views, PDF:554
storing
OLAP storage models, 87-90 OpsMgr, PDF:767
report servers, PDF:558 transformations (packages),
409-415
control flow adjustment, 410-411
data flow adjustment, 411-412
destinations, configuring, 412-413
execution results, 414 warehouses, BI features,
PDF:541
Database Engine, PDF:543 backing up
automating with maintenance plans, PDF:621-PDF:628 copy-only, PDF:613
differential, PDF:607-PDF:609, PDF:618-PDF:619
differential partial, PDF:613 filegroup, PDF:612
full, PDF:605-PDF:607, PDF:615-PDF:618 mirrored, PDF:614 partial, PDF:612 partial log, PDF:613 system databases, PDF:614 transaction log,
PDF:609-PDF:612, PDF:619-PDF:621 collation settings, PDF:667 configuration settings, 52 database objects, scripting, 56 databases
assemblies, PDF:545 attaching, 54-56 backing up/restoring, 56 data transfers, 57 detaching, 53-55
event notifications, PDF:545 federated database servers,
PDF:546 indexes, PDF:544
partitioned tables/indexes, PDF:544
renaming, 59 shrinking, 58 states, PDF:545
stored procedures, PDF:544 storing, PDF:545
structures, PDF:544-PDF:545 system, PDF:545-PDF:546
tables, PDF:544 taking offline, 57 triggers, PDF:544 views, PDF:544
failover clustering installation, PDF:660-PDF:668
Authentication Mode screen, PDF:667
Cluster Group Selection screen, PDF:663 Cluster Node Configuration
screen, PDF:665 Collation Settings screen,
PDF:667
Components to Install screen, PDF:661
domain groups, PDF:666 Error and Usage Report
Settings screen, PDF:667 Instance Name screen,
PDF:662
prerequisites, installing, PDF:661
registration, PDF:661 Remote Account Information
screen, PDF:665 Service Account screen,
PDF:666
Setup Summary screen, PDF:668
SQL Server 2005 installation splash screen, PDF:661 System Configuration Check
screen, PDF:661
Virtual Server Configuration screen, PDF:663
Virtual Server Name screen, PDF:662
folders, 29
Databases, 30-32
Notification Services folder, 36 Replication folder, 36
Security, 32-33
Server Objects folder, 33-36 informational reports, 52-53 new features, 11-12 850 Database Engine
performance/optimization, PDF:792-PDF:793 recovery, PDF:602-PDF:603
bulk-logged, PDF:602 choosing, PDF:603 full, PDF:602,
PDF:629-PDF:632 simple, PDF:602 switching, PDF:604 security, PDF:547-PDF:550
context switching, PDF:550 encryption hierarchy, PDF:550 fixed database role
permissions, PDF:548-PDF:549
fixed server role permissions, PDF:549-PDF:550
module signing, PDF:550 password policies, PDF:550 permissions,
PDF:547-PDF:548 principals, PDF:547 securables, PDF:547 storage architecture, PDF:601 Tuning Advisor, PDF:586
accessing, PDF:586 applying recommendations,
PDF:811-PDF:812 database optimization,
PDF:805 features, PDF:586 indexes, 344-346 monitoring, PDF:762 query analysis, PDF:817 recommendations, reviewing,
PDF:808-PDF:810 requirements, PDF:587 Database Mail, PDF:755
accounts, adding, PDF:758 configuring, PDF:759 enabling/disabling, PDF:757 implementing, PDF:757-PDF:758 security, PDF:758
SMTP server, PDF:756-PDF:757 testing, PDF:759
Database Maintenance Plan Wizard, PDF:622
backup options, PDF:623-PDF:624 full task settings, PDF:625 job scheduling, PDF:625-PDF:627 launching, PDF:622
maintenance plan properties, PDF:622
progress, PDF:628 reports, PDF:627 task options, PDF:623 transaction log task settings,
PDF:626
Database Properties dialog box opening, 37
pages
Extended Permissions, 51 Filegroup, 43
Files, 38-42 General, 37-38 Mirroring, 50 Options, 43 Permissions, 51
Transaction Log Shipping, 51 recovery models, 45
automatic options, 47 Compatibility Level setting, 47 cursor options, 48
miscellaneous options, 48-49 page verification options, 49 selecting, 45-46
state options, 49-50 switching, 46-47 databases
AdventureWorks alerts, PDF:761 attaching, 73-74,
PDF:827-PDF:828
backing up, PDF:630-PDF:631 configuring, PDF:827
differential backup, PDF:607-PDF:608, PDF:618-PDF:619 Documents Catalog,
deleting, 378
downloading, PDF:827 finding, 72
full backup, PDF:606-PDF:607, PDF:615-PDF:618
full-text catalogs, creating, 359-362
full-text filegroups, defining, 357, 359
historical data, deleting, 296 indexes, 293-294
installing, 73 integrity check, 291 logins, adding, 495 mirrored backups, PDF:614 publication configuration,
224-225, 228-229 publications for peer-to-peer
transactional replication, 236-238
shrinking, 292
snapshots, PDF:642-PDF:643 statistics, updating, 296 subscriptions, configuring,
229-233 tail-log backup,
PDF:631-PDF:632 Test Schema, 498 transaction log backup,
PDF:619-PDF:621
transaction log tail-log backup, PDF:610-PDF:612
transaction log truncate backup, PDF:609-PDF:610 Agent jobs, running, 297 Analysis Services
backing up, PDF:637-PDF:638 deploying, 74-80
recovering, PDF:639-PDF:640 assemblies, PDF:545
attaching, 54-56
backing up, 56, 297-298, PDF:605
automating with maintenance plan, PDF:621-PDF:628 copy-only, PDF:613
differential, PDF:607-PDF:609, PDF:618-PDF:619
differential partial, PDF:613 filegroup, PDF:612
full, PDF:605-PDF:607, PDF:615-PDF:618 mirrored, PDF:614 partial, PDF:612-PDF:613 system databases, PDF:614 transaction log,
PDF:609-PDF:612, PDF:619-PDF:621 collation, 43
copying, 430-431 data
historical, deleting, 296, 305 transfers, 57
deleting, 299 detaching, 53-55
disk space, monitoring, PDF:771 distribution, deleting, 247 encryption
authenticators, 519-521 certificates, 515 configuring, 514 data, 515-516
database, creating, 513-514 decrypting, 516
inference attacks, 518-519 keys, backing up, 521-522 master key, creating, 514 event notifications, PDF:545 federated database servers,
PDF:546 files, PDF:601
autogrowth, 42 capacity planning,
checking, 283 creating, 41-42 filegroups, creating, 40 managing, 38-40 size, increasing, 40 full Analysis Services
multidimensional, 81-85
852 databases
health, PDF:771 indexes, PDF:544
rebuilding, 293-295, 302 reorganizing, 302
scanning performance, 293 informational reports,
creating, 91 integrity checks, 302 keys, backing up, 521-522 log shipping, deleting, PDF:740 mail. See Database Mail maintenance plans. See also
Database Maintenance Plan Wizard
Back Up Database Task, 297-298
Check Database Integrity Task, 291
creating manually, 306-309 creating with Maintenance
Plan Wizard, 300-305 daily tasks, 312-313 establishing, 291
Execute SQL Server Agent Job Task, 297
History Cleanup Task, 296 Maintenance Cleanup
Task, 299
monthly tasks, 313-314 multiserver, creating, 311-312 names, 300
new features, 289-290 precedence constraints,
307-308
quarterly tasks, 313-314 Rebuild Index Task, 293-295 Reorganize Index Task, 293 reports, 309
scheduling, 300
Shrink Database Task, 292 tasks, 301, 309
Update Statistics Task, 295-296
viewing, 310-311 weekly tasks, 313
master keys, 512-514 mirroring, PDF:694
client connections/redirects, PDF:712-PDF:713
combining, PDF:699-700 configuring, PDF:702-PDF:707 deleting, PDF:711
endpoints, PDF:696 failover, PDF:695,
PDF:709-PDF:710 failover clustering
combination, PDF:654 high availability,
PDF:696-PDF:697 high performance,
PDF:696-PDF:697 high protection,
PDF:696-PDF:697 log shipping, PDF:727 mirror databases, PDF:694 monitoring, PDF:714-PDF:718 Monitoring tool,
PDF:714-PDF:716 need for, PDF:697-PDF:698 new features, PDF:692 operating modes, changing,
PDF:710-PDF:711 options, 50
overview, PDF:692-PDF:693 pausing/resuming,
PDF:708-PDF:709 prerequisites, PDF:697,
PDF:701-PDF:702
principal databases, PDF:694 quorum, PDF:695
replication combination, 218 synchronous/asynchronous,
PDF:695
transparent client redirects, PDF:695
witness servers, PDF:694, PDF:698-PDF:699 wizard, PDF:703-PDF:705 multidimensional, 68
Notification Services, 153, 172
objects security, 470 scripting, 56 OpsMgr, PDF:778 permissions
Analysis Services, 92-93 options, 51
principal, PDF:694 properties. See Database
Properties dialog box recovery, 43-45,
PDF:602-PDF:603 automatic options, 47 bulk-logged, 45, PDF:602
PDF:602-PDF:603 automatic options, 47 bulk-logged, 45, PDF:602