EXE utility, 70
RTM (release-to-manufacturing), 204, 321
nS
SAN (storage area network), 254, 255??“256,
258
Sarbanes-Oxley Act of 2002, 327
SATA (Serial Advanced Technology
Attachment), 247, 251
scare tactics, 319
Script Configuration button scripts, 164
SCSI (Small Computer System Interface), 247
secondary data files, 14
secondary databases, for reporting, 173
Secondary Global Allocation Map (SGAM), 64
Secure File Transfer Protocol (SFTP), 150
securing backups, 32
Security Identifier (SID), 211
SELECT @@SERVERNAME property, 168
SELECT INTO statement, 19
SELECT queries, 230
separate log backups, 172
Serial Advanced Technology Attachment
(SATA), 247, 251
server environment, 283
server instance, 180
server resource planning, 190
server-room design, 6
servers
renaming, 167??“169
standby, multiple, 150
witness, 200
Service Broker, 204
service pack installation issues, 8
Service Principal Name (SPN), 264
SFTP (Secure File Transfer Protocol), 150
SGAM (Secondary Global Allocation Map), 64
short backup window, 125??“128
overview, 125
potential approach, 125??“127
requirements, 125
risks, 127
SID (Security Identifier), 211
sign-off document, 316
silos roadblock, 317
Simple Recovery mode, 17??“18, 20, 87, 321
restoring differential backups in, 59
restoring full backups in, 53??“54
SINGLE_USER mode, 71
Small Computer System Interface (SCSI), 247
SNAC (SQL Native Access Client), 167,
204??“206, 226
snapping back, 240
snapshots, 167, 241, 242
software cost, 106
SoftwareVendorID field, 49
SortOrder field, 49
source database, 234
SourceDB column, 237
sp_adddumpdevice procedure, 25
sp_change_users_login stored procedure,
211
sp_configure command, 46, 323
space management, 246
sparse file, 230
SPN (Service Principal Name), 264
SPYGLASSTAB\jluetke command-line, 122
SQL Agent, 113??“123, 183
agent proxies, 117??“122
alerts, 122??“123
job schedules, 114
job step tokens, 116??“117
jobs and job steps, 114??“116
overview, 113
SQL Agent service, 113
SQL Native Access Client (SNAC), 167,
204??“206, 226
SQL Server 2000, 155??“156, 163
SQL Server 2008, 321??“328
backup/restore improvements, 321??“326
FILESTREAM data, 324??“326
native backup compression, 322??“324
nINDEX 339
overview, 321
tail-log backups, 322
Change Tracking feature, 327??“328
database mirroring improvements,
326??“327
automatic page repair, 326
overview, 326
speed, 327
overview, 321
SQL Server clustering, 181??“182, 191
SQL Server error log, 198
SQL Server Integration Services (SSIS), 66
SQL Server Recovery modes, 16??“20
Bulk-Logged Recovery, 18??“20
changing, 20
Full Recovery, 17
overview, 16
Simple Recovery, 17??“18
SQL Server storage, 14??“16
sqlservr -m command, 65
SSIS (SQL Server Integration Services), 66
SSL (HTTP over Secure Sockets Layer)HTTPS
(), 150
standby databases, 196
multiple, 145
recovering, 165??“166
???Standby mode??? option, 162
standby recovery mode, 146
standby servers, 142, 150, 165
stateless system, 143??“144
Stop_At column, 52
Stop_At_Mark_Name column, 52
Stop_Before column, 52
STOP_ON_ERROR command, 31, 63
STOPAFTERMARK option, 62
STOPAT clause, 61
STOPBEFOREMARK option, 62
storage area network (SAN), 254, 255??“256,
258
storage devices, 111
stored procedures, 240
strategies, filegroup, 84??“87
isolating specific tables, 86
partitioning tables, 86
reducing backup/restore time, 86??“87
separating clustered indexes/heaps from
nonclustered indexes, 85
separating read-only and read/write
tables, 85
stripe set, 253
stripe size, 245??“246
striped backup, 32??“34, 63
structure backup, 37
surges, power, 264
SUSPECT mode, 112
SUSPECT status, 71??“73, 86
SUSPECT_PAGE table, 31, 64, 73
sys.
Pages:
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625