本书是《微软指定MCDBA教材(影印版)》丛书中的一本,讲述SQL Server 7.0系统管理技能,包括系统安装、权限配置、数据库的创建和管理、备份及恢复、数据转移、服务器之间数据的复制、系统优化、性能监视、故障诊断等。本书还为您准备MCP 70-028考试(面向微软认证数据库管理员和微软认证系统工程师)提供了指导。\r\n 本书由微软公司专家编写,技术深入,权威性强,可作为信息系统专业人员,数据库管理员和MCP考试应试者的参考书。
About This Book \r\nIntended Audience\r\nPrerequistes \r\nReference Materials\r\nAbout the CD-ROMs\r\nFeatures of This Book\r\nChapter and Appendix Overview\r\nFinding the Best Starting Point for You \r\nGetting Started\r\nThe Microsoft Certified Professional Program\r\nTechnical Support\r\n\r\nChapter 1 Wverview of SQL Server\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: What Is SQL Server\r\nClient/Server Architecture\r\nSQL Server Platforms\r\nSQL Server Integration with Windows NT\r\nSQL Server Integration with Microsoft BackOffice\r\nLesson Summary\r\nLesson 2: SQL Server Components\r\nSQL Server Services\r\nSQL Server Client Software\r\nSQL Server Help and SQL Server Books Online\r\nPractice: Using SQL Server Books Online\r\nLesson Summary\r\nLesson 3: Wverview of SQL Server Architecture\r\nCommunication Architecture\r\nData Access Architecture\r\nAdministrative Architecture\r\nApplication Architecture\r\nLesson Summary\r\nLesson 4: Overview of SQL Server Security\r\nLogin Authentication\r\nPermission Validation\r\nDatabase user Accounts and Roles\r\nLesson Summary\r\nReview\r\n\r\nChapter 2 Installation\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Preparing to Install SQL Server \r\nHardware and Software Requirements\r\nSQL Server Installation Options\r\nLesson Summary\r\nLesson 2: Running SQL Server \r\nSetup and Testing the installation \r\nTypes of SQL Server installation\r\nTesting the Installation\r\npractice: Using a Graphical utility to Connect to SQL Server \r\nLesson Summary\r\nLesson 3: Performing an Unattended Installation\r\nUsing the Sample Unattended Inatallation\r\nGenerating or Creating a Custom Setup Initialization Script File\r\nInvoking Setup\r\nUsing Microsoft Systems Management Server\r\nLesson Summary\r\nReview\r\n\r\nChapter 3 Upgrading to SQL Server 7.0\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Introduxtion to Upgrading SQL Server \r\nThe Upgrade Process\r\nUpgrade Considerations\r\nUpgrade Summary\r\nLesson 2: Using the SQL Server Upgrade Wizard\r\nChoosing an Upgrade method\r\nSelecting Upgrade Options \r\nRunning the Upgrade\r\nLesson Summary\r\nLesson 3: After Using the SQL Server Upgrade Wizard\r\nRemoving SQL Server 6.5\r\nTroubleshooting the Upgrade\r\nSpecifying Compatibility Levels\r\nBackward Compatibility Details\r\nLesson Summary\r\nReview\r\n\r\nChapter 4 System Configuration and Architecture\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Preparing to Use SQL Server \r\nConfiguring SQL Server Enterprise Manager\r\nClient Installation\r\nConfiguring SQL Server \r\nTroubleshootin SQL Server Installation\r\nLesson Summary\r\nLesson 2: Working with SQL Server \r\nSQL Server Activities\r\nClient/Server Tools\r\nLesson Summary\r\nLesson 3: SQL Server Databases\r\nTypes of Databases\r\nDatabase Objects\r\nSystem Tables\r\nLesson Summary\r\nReview\r\n\r\nChapter 5 Database Files\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Introduction to Databases\r\nHow Data Is Stored\r\nSQL Server Database Files\r\nhow the Transaction Log Works\r\nLesson Summary\r\nLesson 2: Creating and Dropping Databases\r\nCreating Databases\r\nDropping a Database\r\nLesson Summary\r\nLesson 3: Managing Databases\r\nDatabase Options\r\nManaging Data and Log File Growth\r\nLesson Summary\r\nLesson 4: Managing Databases on Multiple Disks\r\nLeveraging Windows NT Server Fault Tolerance\r\nCreating Filegroups\r\nPerformance Considerations\r\nLesson Summary\r\nLesson 5: Capacity Planning \r\nEstimating the Minimum Size of a Database\r\nLesson Summary\r\nReview\r\n\r\nChapter 6 Transferring Data\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Introduction to Transferring Data\r\nWhy Transfer Data\r\nWhy Transform Data\r\nTools for Transferring Data in SQL Server\r\nLesson Summary\r\nLesson 2: Introduction to Data Transformation Services\r\nOverview of DTS\r\nThe DTS Process\r\nDTS Tools\r\nLesson Summary\r\nLesson 3: Transforming Data with DTS\r\nRestructuring and Mappign Data\r\nDefining workflows\r\nExecuting and Scheduling a DTS Package\r\nLesson Summary\r\nLesson 4: Linked Servers\r\nIntroduction to Linked Servers\r\nAdding Linked Servers\r\nSecurity Considerations for Linked Servers\r\nSystem Stored procedures for Working with Linked Servers\r\nExecuting a Distributed Query\r\nLesson Summary\r\nReview\r\n\r\nChapter 7 Web Publishing and Full-Text Indexing \r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Publishing Database Data to Web Pages\r\nHow Web Publishing Works\r\nSpecifying Web Page Characteristics\r\nUsing an HTML Template File \r\nManaging Web Assistant Jobs\r\nLesson Summary\r\nLesson 2: Full-Text Indexing and Searching\r\nIntroduction to Full-Text Searching \r\nFull-Text Search with SQL Server 7\r\nIntroduction to Creation Full-Text Indexes\r\nMaintaining Full-Text Indexes\r\nSetting Up Full-Text Search\r\ngetting Information About Full-Text Search\r\nWriting Full-Text Queries\r\nLesson Sunnary\r\nReview\r\n\r\nChapter 8 Backup and Restore Overview and Strategy\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Backup Overview\r\nPreventing Data Loss\r\nUsing Backup and Restore for Other Purposes\r\nSQL Server Backup\r\nPerforming and Storing Backups\r\nThe SQL Server Online Backup Process\r\nWhen to Back Up Databases\r\nLesson Summary\r\nLesson 2: Backup Strategy\r\nPlanning a Backup Strategy\r\nPerformance Considerations\r\nlesson Summary\r\nreview\r\n\r\nChapter 9 Backing Up Databases\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Backup Devices \r\nOverview of Backup Devices \r\nCreating Named Backup Devices \r\nCreating Temporary Backup Devices \r\nUsing Multiple Backup Devices to Store Backups\r\nLesson Summary\r\nLesson 2: Performing Backups\r\nUsing the BACKUP Statement\r\nPerforming a Complete Database Backup\r\nPerforming a Transaction Log Backup\r\nClearing the Transaction Log \r\nPerforming a Differential Backup\r\nPerforming Data File or Filegroup Backups\r\nLesson Summary\r\nReview\r\n\r\nChapter 10 Restoring Databases\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: The SQL Server\r\nRecovery and Restore Processes\r\nDatabase Recovery\r\nSQL Server Activities During the Restore Process\r\nLesson Summary\r\nLesson 2: The RESTORE Statement\r\nPreparing to Restore a Database\r\nLesson Summary\r\nLesson 3: Performing a Database Restore\r\nRestoring from a Complete Dababase Backup\r\nRestoring from a Differential Backup\r\nRestoring from a transaction Log Backup\r\nPractice: Restoring a Database\r\nLesson Summary\r\nLesson 4: Using a Standby SQL Server \r\nSetting Up a Standby SQL Server \r\nUsing the Standby SQL Server as a Read-Only Server\r\nusing the Standby SQL Server \r\nto Troubleshoot Data Corruption\r\nReplacing a Production Server with a Standby SQL Server \r\nRestoring the production Server\r\nUsing Clustering \r\nLesson Summary\r\nReview\r\n\r\nChapter 11 Logins, User Accounts, and User Roles\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Adding Login Accounts\r\nDefault Databases\r\nDefault Login Accounts\r\nGranting a Windows NT ccount Access to SQL Server \r\nAdding a SQL Server Login\r\nLesson Summary\r\nLesson 2: How Login Accounts\r\nAre Authenticated When Users Connect\r\nAuthentication Processing \r\nHow SQL Server Processes\r\nLogins That Windows NT Authenticates\r\nHow SQL Server Processes Login That It Authenticates\r\nChoosing an Authentication Mode\r\nStep in Implementing One of the Authentication Modes\r\nLesson Summary\r\nLesson 3: Granting Access to Databases\r\nGranting Database Access to Logins\r\nAssigning Logins to Roles\r\nLesson Summary\r\nReview\r\n\r\nChapter 12 Permissions and Security Planning \r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: types of Permissions \r\nThe Three Types of Permissions\r\nLesson Summary\r\nLesson 2: Assigning Permissions to Users and Roles\r\npermission States\r\nGranting Permissions\r\nDenying Permissions\r\nRevoking Granted and Denied Permissions\r\nWhen a Revoke Is Not a Revoke\r\nLesson Summary\r\nLesson 3: Planning Security\r\nGoals in Creating a Security Plan\r\nDetermine the Use of Default Logins\r\nDetermine public Role Permissions\r\nDetermine the function of the guest User Account\r\nLesson Summary\r\nLesson 4: Managing Application Security\r\nManaging Security with Views and Stored Procedures\r\nManaging Security with Application Roles\r\nManaging Application Role Permissions\r\nActivating Application Roles\r\nLesson Summary\r\nReview\r\n\r\nChapter 13 Automating Adminstrative Tasks\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Introduction to SQL Server Automated Administration\r\nReasons to Automate\r\nComponents of SQL Server Automated Administration\r\nProcessing Jobs and Alerts\r\nPreparing to Automate\r\nPractice: Configuring Mail Profiles\r\nLesson Summary\r\nLesson 2: Automating Routine Maintenance Tasks\r\nCreating Operators to Notify\r\nCreating Jobs\r\nDefining Job Steps\r\nDetermining Action Flow Logic for Each Job Step\r\nScheduling Jobs\r\nMultiple Schedules\r\nReviewing and Configuring job History\r\npractice: Configuring SQL Mail\r\nLesson Summary\r\nLesson 3: Creating Alerts\r\nUsing Alerts to Respond to Potential Problems\r\nCreating Alerts to Respond to SQL Server Errors\r\nConfiguring Event Forwarding\r\nReaponding to Performance Condition Alerts\r\nPractice: Creating a Performance Condition Alert\r\nAssigning a Fail-Safe Operator\r\nLesson Summary\r\nLesson 4: Troubleshooting SQL Server Automated Administration\r\nAutomated Administration Troubleshooting Checklist\r\ntroubleshooting Alerts\r\nLesson Summary\r\nLesson 5: Establishing a Multiserver Environment\r\nGrouping Multiple Servers\r\nAutomating Jobs in a Multiserver Environment\r\nLesson Summary\r\nReview\r\n\r\nChapter 14 Monitoring and Maintaining SQL Server\r\n\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Why Monitor SQL Server\r\nReasons to Monitor SQL Server\r\nFactors That Affcet Performance\r\nDetecting Performance Bottlenecks\r\nConfiguring a Query Governor\r\nLesson Summary\r\nLesson 2: Tools for monitoring SQL Server\r\nCommon Monitoring Tasks\r\nUsing the Windows NT Event Viewer\r\nUsing SQL Server Performance Monitor\r\nPractice: Monitoring SQL Server\r\nActivity with SQL Server Performance Monitor\r\nUsing Transact-SQL to Monitor SQL Server\r\nUsing SQL Server Profiler\r\nUsing SQL Server Query Analyzer\r\nUsing Current Activity in SQL Server Enterprise Manager\r\npractice: Managing Locks\r\nLesson Summary\r\nLesson 3: Maintaining SQL Server\r\nDeveloping a Database Maintenance Plan\r\nAutomating the Database Maintenance Plan Tasks\r\nLesson Summary\r\nReview\r\n\r\nChapter 15 Introducing Repllcation\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: introduction to Distributed Data\r\nThe Need for Distributing Data\r\nConsiderations for Distributing Data\r\nMethods of Distributing Data with SQL Server \r\nLesson Summary\r\nLesson 2: introduction to SQL Server Replication\r\nThe Publisher-Subscriber Metaphor\r\nPublications and Articles\r\nFiltering Data\r\nSubscriptions\r\nLesson Summary\r\nLesson 3: SQL Server Replication Types\r\nSnapshot Replication\r\nThe Snapshot Replication Process\r\nTransactional Replication\r\nThe Transactional Replication Process\r\nThe Immediate Updating Subscribers Option\r\nMerge Replication\r\nSQL Server Replication Agents\r\nLesson Summary\r\nLesson 4: Physical Replication Models \r\nOverview of the Replication Models \r\nCombining Replication Models and Types\r\nLesson Summary\r\nReview\r\n\r\nChapter 16 planning and Setting Up Replication\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Planning Replication\r\nDesign Considerations\r\nDetermining a Replication Solution\r\nData Definition Issues\r\nConfiguring Network Security Access\r\nLesson Summary\r\nLesson 2: Preparing the Servers\r\nSetting Up a Distributor\r\nConfiguring a Distributor\r\nSetting Up a Publisher\r\nSetting Up a Subscriber\r\nAgent Profiles\r\nPractice: Replication Exercises\r\nLesson Summary\r\nLesson 3: Publishing \r\nCreating Publications\r\nUsing the Immediate updating Subscribers Option\r\nPublishing Comsiderations\r\nInitial Synchronization\r\nEditing Publication Properties\r\nAgents Created for a Publication\r\nLesson Summary\r\nLesson 4: Subscribing \r\nSetting Up Push and Pull Subscriptions\r\nUsing the Immediate Updating Subscribers Option\r\nEditing Subscription Properties\r\nAgents Creatde for a Subscription\r\nLesson Summary\r\nReview\r\n\r\nChapter 17 manahing Replication\r\n\r\nAbout This Chaper\r\nBefore You Begin\r\nLesson 1: Monitoring and Troubleshooting Replication\r\nUsing SQL Server Replication Monitor \r\nMaintaining Replication\r\nUsing Replication scripts\r\nMonitoring SQL Server Replication Performance\r\nTroubleshooting Replication\r\nLesson Summary\r\nLesson 2: Replicating in Heterogeneous Environments\r\nReplicating Data with ODBC\r\nPublishing Data to Heterogeneous Subscribers\r\nReplicating from Heterogeneous Databases\r\nMaking a Publication Available on the Internet\r\nLesson Summary\r\nReview\r\n\r\nAppendix A Questions and Answers\r\nAppendix B Database Schemata\r\n\r\nGlossary\r\n\r\nIndex
无封面