Microsoft SQL Server 2000系統(tǒng)管理（影印版）

定　價：￥148.00

作　者：	（美）Microsoft公司著
出版社：	北京大學(xué)出版社
叢編項：
標(biāo)　簽：	Sever

購買這本書可以去

當(dāng)當(dāng)網(wǎng) (￥125.80)

ISBN：	9787900632838	出版時間：	2001-01-01	包裝：
開本：	23cm＋光盤1片	頁數(shù)：	689頁	字?jǐn)?shù)：

內(nèi)容簡介

　　本書為微軟指定教材，通過學(xué)習(xí)本書，您將學(xué)會如何優(yōu)化商業(yè)信息系統(tǒng)性能及增強其可伸縮性，同時為MCP認(rèn)證考試做準(zhǔn)備。書中含有系統(tǒng)課程和大量練習(xí)題，可以幫您獲得安裝，配置SQLserver 2000并進行故障排除的實際經(jīng)驗。當(dāng)您獲得真實世界數(shù)據(jù)庫管理技能時，您也為MCP 70-228考試做好了準(zhǔn)備。本書主要內(nèi)容：●安裝或升級到SQL Server 2000●配置數(shù)據(jù)庫選項（包括容量、連接、性能等）●用數(shù)據(jù)傳輸服務(wù)（DTS）包實現(xiàn)數(shù)據(jù)傳輸和處理自動化●使用SQL SERVER復(fù)制服務(wù)●安全管理，包括身份驗證、登錄權(quán)、許可和報警等●用SQL Sever Agent、SQL Profiler和Microsoft Windows System Monitor等對系統(tǒng)性能進行監(jiān)控和調(diào)試●系統(tǒng)備份和恢復(fù)光盤內(nèi)容：●全面的、符合MCP考試目標(biāo)的訓(xùn)練手冊●技能訓(xùn)練練習(xí)，幫您即學(xué)即用●每課小節(jié)和課后復(fù)習(xí)問題，幫您評估學(xué)習(xí)進展情況●SQL SERVER 2000 Enterprise Edition 120 天試用版●本書電子版及范例數(shù)據(jù)庫和技術(shù)白頁

作者簡介

暫缺《Microsoft SQL Server 2000系統(tǒng)管理（影印版）》作者簡介

圖書目錄

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