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