Microsoft SQL Server 2000系统管理（影印版）

AboutThisBook

Chapter1OverviewofSOLserver2000

AboutThisChapter

Lessonl:WhatIsSQLServer2000?

TheSQLServer2000Environment

SQLServer2000Components

SQLServer2000RelationalDatabaseEngine

SQLServer2000AnalysisServices

ApplicationSupport

AdditionalComponents

SQLServer2000Editions

IntegrationwithWindows2000andWindowsNT4.0

LessonSummary

Lesson2:WhatAretheSQLServer2000Components?

ServerComponents

Client-BasedAdministrationToolsandUtilities

ClientCommunicationComponents

SQLServerBooksOnline

LessonSummary

Lesson3:WhatIstheRelationalDatabaseArchitecture?

SystemandUserDatabases

PhysicalStructureofaDatabase

LogicalStructureofaDatabase

LessonSummary

Lesson4:WhatIstheSecurityArchitecture?

Authentication

Authorization

LessonSummary

Review

Chapter2InstallingSQLServer2000

AboutThisChapter

BeforeYouBegin

Lessonl:PlanningtoInstallSQLServer2000

WhatIstheMinimumHardwareRequired?

ExceedingMinimumComputerHardwareRequirements

LessonSummary

Lesson2:DecidingSQLServer2000SetupConfigurationOptions

DeterminingtheAppropriatCUserAccount

fortheSQLServerandSQLServerAgentServices

Practice:CreatingaDedicatedWindows2000UserAccount

ChoosinganAuthenticationMode

DeterminingCollationSettings

Practice:DeterminingYourWindowsCollation

SelectingNetworkLibraries

DecidingonaClientLicensingMode

LessonSummary

Lesson3:RunningtheSQLServer2000SetupProgram

RunningtheSQLServer2000SetupProgram

UnderstandingInstallationTypes

SelectingaSetuprype

Practice:InstallingaDefaultInstanceofSQLServer2000

LessonSummary

Lesson4:UsingDefaultNamed,andMultipleInstancesofSQLServer2000

InstallingMultipleInstancesofSQLServer2000

UsingMultipleInstancesofSQLServer2opEffectivelyandAppropriately

UnderstandingSharedComponentsBetweenInstances

UnderstandingUniqueComponentsBetweenInstances

WorkingwithDefaultandNamedInstancesofSQLServer2000

LessonSummary

besson5:PerfomingUnattendedandRemoteInstallationsofSQLServer2000

PerforminganUnattendedInstallationofSQLServer2000

CreatingSetupInitializationFilesforSQLServer2000

Practice:Performingan

UnattendedInstallationofaNamedInstanceofSQLServer2000

PerformingaRemoteInstallationofSQLServer2000

LessonSummary

Lesson6:TroubleshootingaSQLServer2000Installation

ReviewingSQLServer2000SetupProgramLogFiles

AccessingSQLServer2000TroubleshootingInformationOnline

ReviewingtheSQLServerErrorLogandtheWndOwsApplicationLog

Practice:ReviewingtheSQLServer

ErrorLogandtheWindowsApplicationLog

LessonSummary

Review

Chapter3PreparingtoUseSQLServer2000

AboutThisChapter

BeforeYouBegin

Lesson1:ReviewingtheResultsofInstallation

WhatFilesandFoldersWereAdded?

WhatPermissionsWereSetintheNTFSFileSystem

Practice:ReviewingtheFilesandFoldersThatWereCreated

WhatRegistryKeysWereAdded

WhatPermissionsWereSetonRegistryKeys

Practice:ReviewingPermissionsonRegistryKeys

WhatProgramsWereAddedtotheStartMenu

LessonSummary

Lesson2:Starting,Stopping,Pausing,

andModifyingSQLServer2000Services

WhatIstheDefaultConfigurationforEachSQLServerService?

Starting,Stopping,andPausingSQLServer2000Services

Practice:StartingSQLServerServices

ChangingtheSQLServerorSQL

ServerAgentServiceAccountAfterSetup

LessonSummary

Lesson3:WorkingwithOsql,SQL

QueryAnalyzer,andSQLServerEnterpriseManager

WorkingwithOsql

Practice:UsingOsqltoQuerySQLServer2000Instances

WorkingwithSQLQueryAnalyzer

Practice:UsingSQLQueryAnalyzertoQuerySQLServer2000Instances

WorkingwithSQLServerEnterpriseManager

Practice:WorkigwiththeSQLServerEnterpriseManagerMMCConsole

LessonSummary

Review

Chapter4UpgradingtoSQLServer2000

AboutThisChapter

BeforeYouBegin

Lesson1:PreparingtoUpgrade

WorkingwithMultipleVersionsofSQLServerontheSameComputer

ChoosingtheAppropriateUpgradeProcessandMethod

DeterminingHardwareandSoftwareRequirements

PreparingfortheActualUpgrade

LessonSummary

Lesson2:PerformingaVersionUpgradefromSQLServer7.0

PerformingaVersionUpgrade

PerformingPost-UpgradeTasks

ManuallyUpgradingMetaData

ServicesTablesandtheRepositoryDatabase

LessonSummary

Lesson3:PerforminganOnlineDatabaseUpgradefromSQLServer7.0

PerforminganOnlineDatabaseUpgrade

PerformingPost-UpgradeTasks

LessonSummary

Lesson4:PerformingaVersionUpgradefromSQLServer6.5

PerformingaVersionUpgrade

TroubleshootingaSQLServer6.5Upgrade

SpecifyingaBackwardCompatibilityLevelforUpgradedDatabases

LessonSummary

Review

Chapter5UnderstandingSystemandUserDatabases

AboutThisChapter

BeforeYouBegin

Lesson1:UnderstandingtheDatabaseArchitecture

IntroducingDataFiles

Practice:ViewingthePropertiesofaDataFile

AllocatingSpaceforTablesandIndexes

StoringIndexandDataPages

LessonSummary

Lesson2:UnderstandingtheTransactionLogArchitecture

IntroducingTransactionLogFiles

HowtheTransactionLogWorks

IntroducingRecoveryModels

Practice:ViewingthePropertiesofaTransactionLogandaDatabase

LessonSummary

Lesson3:UnderstandingandQueryingSystemandDatabaseCatalogs

IntroducingSystemTables

RetrievingSystemInformation

Practice:QueryingSystemTablesDirectly

Practice:QueryingSystemTablesUsingSystemStoredProcedures

Practice:QueryingSystemTablesUsingSystemFunctions

Practice:QueryingSystemTablesUsingInformationSchemaViews

LessonSummary

Review

Chapter6CreatingandConfiguringUserDatabases

AboutThisChapter

BeforeYouBegin

Lesson1:CreatingaUserDatabase

CreatingaUserDatabase

UsingSQLServerEnterpriseManagertoCreateaUserDatabase

Practice:CreatingaDatabaseUsingthe

CreateDatabaseWizardinSQLServerEnterpriseManager

Practice:CreatingaDatabaseDirectly

UsingSQLServerEnterpriseManager

UsingtheCREATEDATABASE

Transact-SQLStatementtoCreateaUserDatabase

Practice:CreatingaDatabaseinSQLQueryAnalyzer

UsingtheCREATEDATABASETransact-SQLStatement

ScriptingDatabasesandDatabaseObjects

UsingSQLServerEnterpriseManager

Practice:GeneratingaTransact-SQL

ScripttoRe-createtheTSQLDBDatabase

LessonSummary

Lesson2:SettingDatabaseOptions

IntroducingDatabaseOptions

ViewingDatabaseOptionSettings

ModifyingDatabaseOptions

LessonSummary

Lesson3:ManagingUserDatabaseSize

UsingAutomaticFileGrowthAppropriately

Practice:ConfiguringAutomatic

FilegrowthSettingsUsingSQLServerEnterpriseManager

UsingAutomaticFileShrinkageAppropriately

ControllingDataFileSizeManually

Practice:ModifyingDataFileSizeUsingSQLServerEnterpriseManager

ControllingTransactionLogFileSizeManually

CreatingAdditionalDataandTransactionLogFiles

LessonSummary

Lesson4:PlacingDatabaseFilesonMultipleDisks

IntroducingRAID

IntroducingFilegroups

ConfiguringYourSQLServer2000Disk

SubsystemforPerformance,FaultTolerance,andRecoverability

MovingDataandTransactionLogFiles

LessonSummary

Review

Chapter7PopulatingaDatabase

AboutThisChapter

BeforeYouBegin

Lesson1:TransfetringandTransfonningData

ImportingData

DTSDataTransformations

IntroducingtheDataTransferTools

LessonSummary

Lesson2:IntroducingMicrosoftDataTransformationServices(DTS)

UnderstandingaDTSPackage

DTSPackageStorage

IntroducingDTSTools

LessonSummary

Lesson3:TransferringandTransformingDatawithDTSGraphicalTools

UsingtheDTSImport/ExportWizard

Practice:TransfetrringTablesandData

fromtheNorthwindDatabaseUsingtheDTSImport/ExportWizard

UsingDTSDesigner

Practice:CreatingaDataTransferandTransformPackage

UsingDTSDesigner

ExtendingDTSPackageFunctionality

LessonSummary

Lesson4:WorkingwithDTSPackages

UnderstandingDTSPackageStorageOptions

UsingDTSPackageExecutionUtilities

UsingDTSPackageLogsandExceptionFiles

PerformingDisconnectedEdits

LessonSummary

Lesson5:UsingtheBulkCopyProgram(Bcp)

andtheBULKINSERTTransact-SQLStatement

CopyingDatainBulkUsingTextFiles

UsingBcp

Practice:ImportingDataUsingBcp

UsingtheBULKINSERTTransact-SQLStatement

OptimizingBulkCopyOperations

LessonSummary

Review

Chapter8DeveloplngaDataRestoratlonStrategy

Lesson1:UnderstandingDataRestorationIssues

Lesson2:UnderstandingtherypesofDatabaseBackups

Lesson3:UnderstandingtheRostorationProcess

Review

Chapter9BackingUpandRestoringSQLServer

AboutThisChapter

BeforeYouBegin

Lesson1:UnderstandingBackupTorms,Media,andDevices

DefiningTerms

SelectingBackupMedia

CreatingPermanentBackupDevices

Practice:CreatingBackupDevicesUsingTransact-SQL

LessonSummary

Lesson2:BackingUpDatabases,Files,Filegroups,andTransactionLogs

PerformBackupsUsingSQLServerEnterpriseManager

Practice:BackingUpthemasterDatabase

UsingtheCreateDatabaseBackupWizard

Practice:BackingUpthemsdbDatabase

DirectlyUsingSQLServerEnterpriseManager

PerformBackupsUsingTransact-SQL

Practice:PerformingBackupsUsingTransact-SQL

DessonSummary

Lesson3:RestoringaUserDatabase

DeterminingtheDataRestorationSequence

Practice:RetrievingBackupMediaInformation

PerformingRestorationsUsingSQLServerEnterpriseManager

Practice:PerformingaCompleteDatabaseRestoration

Practice:PerformingaDatabase

RestorationtoaSpecifiedPointinTime

PerformingRestorationsUsingTransact-SQL

Practice:PerformingRestorationsUsingTransact-SQL

LessonSummary

Lesson4:RestoringandRebuildingSystemDatabases

RestoringtheMasterDatabase

RebuildingtheSystemDatabases

LessonSummary

Review

Chapter10ManagingAccesstoSQLServer2000

AboutThisChapter

BeforeYouBegin

Lesson1:UnderstandingtheAuthenticahonProcess

UnderstandingtheSQLServer2000AuthenticationProcess

ComparingWindowsAuthenticationandSQLServerAuthentication

SelectingaSQLServer2000AuthenticationMode

Practice:SwitchingSQLServer2000AuthenticationModes

UnderstandingSecurityAccountDelegahon

LessonSummary

Lesson2:UnderstandingtheAuthorizationProcess

UnderstandingServer-WidePetrissions

UnderstandingDatabase-SpecificPendssions

LessonSummary

Lesson3:CreatingandManagingLogins

GrantingAccessUsingSQLServerEnterpriseManager

Practice:CreatingaLoginUsingtheCreateLoginWizard

Prahce:CreatingaLoginDirectlyUsingSQLServerEnterpriseManage

GrantingAccessUsingTransact-SQLStatements

Practice:GrantingSQLServer2000

andDatabaseAccessUsingTransact-SQL

ViewingAccessInformation

Practice:ViewingSQLServer2000AccessInformation

LessonSummary

Review

Chapter11ManagingSQLServerPermisslons

AboutThisChapter

BeforeYouBegin

Lessonl:GrantingDatabase-SpecificPermissions

ImplementingPermissions

Practice:CreatingandTestingPermissionConflicts

ManagingStatementPermissions

Practice:GrantingandTestingStatementPermissions

ManagingObjectPermissions

ViewingPermissions

Practice:GrantingandTestingObjectPermissions

LessonSummary

Lesson2:UsingApplicationRoles

UnderstandingApplicationRoles

CreatingApplicationRoles

ActivatingandUsingApplicationRoles

Practice:CreatingandTestingApplicationRoles

LessonSummary

Lesson3:DesigninganAccessandPermissionsStrategy

PermittingAdministratorAccess

UsingWindowsGroupsandSQLServer2000ServerRoles

ProvidingSQLServer2000Access

ProvidingDatabaseAccess

UsingFixedDatabaseRolesforAdministrativeAccess

ProvidingDataAccess

LessonSummary

Review

Chapter12PerformingAdministrativeTasks

AboutThisChapter

BeforeYouBegin

Lessonl:PerformingConfigurationTasks

ConfiguringWindows2000(andWindowsNT4.0)

ConfiguringtheSQLServerService

ConfiguringtheServiceAccount

ConfiguringtheSQLServerAgentService

RegisteringSQLServer2000

InstanceswithSQLServerEnterpriseManager

SharingRegistrationInformation

LessonSummary

Lesson2:SettingUpAdditionalFeatures

SettingUpSQLMailandSQLAgentMail

SettingUpLinkedServers

Practice:SettingUpandTestingaLinkedServerConfiguration

CreatinganODBCSQLServerDataSource

ConfiguringSQLServerXMLSupportinIIS

Practice:CreatinganIISVirtualDirectory

LessonSummary

Lesson3:PerformingMaintenanceTasks

UpdatingDistributionStatistics

MaintainingIndexes

MaintainingFull-TextIndexes

LessonSummary

Review

Chapter13AutomatingAdministrativeTasks

AboutThisChapter

BeforeYouBegin

Lessonl:DefiningOperators

MethodsofNotification

Fail-SafeOperators

CreatingOperators

CreatingaFail-SafeOperator

Prattice:CreatingOperatorsandSettingaFail-SafeOperator

LessonSummary

Lesson2:CreatingJobs

ImplementingJobs

CreatingJobs

Practice:CreatingaJobUsingtheCreateJobWzard

Practice:CreatinaJobUsingSQLServerEnterpriseManagerDirectly

UsingTransact-SQL

ReviewingJobsandJobHistory

Practice:ReviewingandModifyingaJobandViewingJobHistory

LessonSummary

Lesson3:ConfiguringAlerts

DefiningAlerts

ConfiguringAlerts

Practice:CreatinganEventAlertUsingtheCreateAlertWizard

Practice:CreatingaPerformanceCondition

AlertUsingSQLServerEnterpriseManagerDirectly

ReviewingAlertsandAlertHistory

LessonSummary

Lesson4:CreatingaDatabaseMaintenancePlan

UsingtheDatabaseMaintenancePlanWizard

ViewingandModifyingDatabaseMaintenancePlans

UsingtheSqlmaintUtility

LessonSummary

Lesson5:CreatingMultiserverJobs

CreatingMasterandTargetServers

CreatingJobsforTargetServers

MonitoringJobsonTargetServers

Practice:CreatingaMultiserverJob

LessonSummary

Review

Chapter14MonitoringSQLServerPerformanceandAotivity

AboutThisChapter

BeforeYouBegin

Lessonl:DevelopingaPerformanceMonitoringMethodology

EstablishingMonitoringGoals

DeterminingResourcesandActivitiestoMonitor

LessonSummary

Lesson2:ChoosingAmongMonitoringTools

UsingSystemMonitor

UsingTaskManager

UsingSQLProfiler

UsingSQLQueryAnalyzer

UsingtheSQLServerEnterpriseManagerCurrentActivityWindow

UsingTransact-SQL

UsingSNMP

LessonSummary

Lesson3:PerformingMonitoringTasks

MonitoringResourceUsage

Practice:MonitoringSystemResources

UsingSystemMonitorandTaskManager

MonitoringStotedProcedurs,TransactSQLBatches,andUserActivity

Practice:MonitoringSQLBatchesandStoredProcedures

MonitoringCurrentLockingandUserActivity

Practice:MonitoringBlockingProblemsUsingthe

CurrentActivityWindowandSystemStoredProcedures

LessonSummary

Review

Chapter15UsingSQLServerReplication

AboutThisChapter

BeforeYouBegin

Lessonl:lntroducingReplication

DescribingReplication

UnderstandingtheTypesofReplication

SelectingaPhysicalReplicationModel

ChoosingReplicationImplementationTools

LessonSummary

Lesson2:PlanningforReplication

PlanningforReplicationSecurity

FilteringPublishedData

ChoosingInitialSnapshotOptions

LessonSummary

Lesson3:ImplementingReplication

ConfiguringDistributorandPublisherProperties

Practice:ConfiguringaDistributor

CreatingaPublication

Practice:CreatingaTransactionalPublication

Practice:CreatingaMergePublication

ConfiguringPushSubscriptions

Practice:CreatingaPushSubscription

ConfiguringaPullSubscription

Practice:CreatingaPullSubscription

LessonSummary

Lesson4:MonitoringandAdministeringReplication

MonitoringwithReplicationMonitor

PracticefMonitoringReplication

ReviewingandModifyingDistributorProperties

ReviewingandModifyingPublicationProperties

ReviewingandModifyingReplicationAgentProfile

ReviewingandModifyingSubscriptionProperties

PracticefResolvingConflictsInteractively

UsingWindowsSynchronizationManager

LessonSummary

Review

Chapter16MaintainingHighAvailability

AboutThisChapter

BeforeYouBegin

Lessonl:UsingStandbyServers

UsingaStandbyServer

AutomatingLogShipping

Practice:CreatingaStandbyServer

MonitoringLogShipping

Practice:MonitoringLogShipping

BringingaStandbyServerOnline

Practice:BringingaStandby

ServerOnlineasthePrimaryServer

LessonSummary

Lesson2:UsingFailoverClustering

IntroducingMSCS

CreatingaVirtualServeronaServerCluster

LessonSummary

Review

Appendix

Glossary

Index