mail system security, 532
maintaining databases
database consistency checks. See database consistency checks
database maintenance plans, 324–335, 325–335
exam essentials, 351
job dependency diagrams, 320–321
multiserver administration, 321–322, 322
Reporting Services. See SQL Server Reporting Services (SSRS)
review questions, 352–358
SQL Server Health and History tool, 322–324
summary, 350–351
tasks, 294–296
maintenance plans
Replication Monitor for, 504–505
SSIS packages, 375
management personnel for data assessment, 401
manual updates, 566
mappings, login, 464–468
Mars Deadlocks counter, 232
master servers (MSX), 322
MaxBCPThreads parameter, 509
MAXDOP query hint, 91
MBSA (Microsoft Baseline Security Analyzer), 565
MEDIAPASSWORD option, 192–193
memory
for locks, 123
performance object counters
baselines, 230
thresholds, 236
troubleshooting, 22–23, 42–44
Memory Consumption report, 25, 26
Memory Grants Pending counter, 238
Memory Subsystem for baselines, 230
MEMORYSTATUS command, 44
Merge Agent (replmerge.exe), 175, 479–480
Merge Join transforms, 377
merge replication, 175, 478
conflicts, 506–508, 507–508
multiple master approach, 432–433, 432
Merge transforms, 377
Message Queue task, 374
message types in Service Broker, 276
METADATA resource, locks for, 128
Microsoft Baseline Security Analyzer (MBSA), 565
Microsoft.Jet.OLEDB.4.0 provider, 462
Microsoft Update, 566
migration scripts, 545–546
MIRROR TO clause
BACKUP DATABASE, 190
BACKUP LOG, 191
mirroring
database, 172
RAID, 166–168, 167–168
Missing Column Statistics event class, 240
missing indexes, 79
Missing Join Predicate event class, 240
missing updates, 565
Mobius Management Systems, Inc., 399
money data type, 441
monitoring, 222
automatic, 221
component selection for, 222
latches, 119–121
physical servers. See physical server monitoring
for quality data, 403
replication. See Replication Monitor
in security, 533
tools, 222–224
MOVE option, 197
moving
reportserver database, 349, 349
SSIS packages, 382–383
MSDAORA provider, 462
MSDASQL provider, 462
MSrepl_commands table, 479
MSrepl_transactions table, 479
MSRS 2005 Web Service object, 343
MSRS 2005 Windows Service object, 343
MSSQLServer service, 559
MSX (master servers), 322
multi-instance clusters, 171, 171
Multicast transforms, 377
multiple copies, single maintenance approach, 427–428
multiple master approach
merge replication, 432–433, 432
peer-to-peer replication, 433–434, 433
multiple package versions, 361
multiserver administration, 321–322, 322