About This Book | |
Overview of SQL Server 2000 | |
What Is SQL Server 2000? | |
What Are the SQL Server 2000 Components? | |
What Is the Relational Database Architecture? | |
What Is the Security Architecture? | |
Installing SQLServer 2000 | |
Planning to Install SQL Server 2000 | |
Deciding SQL Server 2000 Setup Configuration Options | |
Running the SQL Server 2000 Setup Program | |
Using Default, Named, and Multiple Instances of SQL Server 2000 | |
Performing Unattended and Remote Installations of SQL Server 2000 | |
Troubleshooting a SQL Server 2000 Installation | |
Preparing to Use SQL Server 2000 | |
Reviewing the Results of Installation | |
Starting, Stopping, Pausing, and Modifying SQL Server 2000 Services | |
Working with Osql, SQL Query Analyzer, and SQL Server Enterprise Manager | |
Upgrading to SQL Server 2000 | |
Preparing to Upgrade | |
Performing a Version Upgrade from SQL Server 7.0 | |
Performing an Online Database Upgrade from SQL Server 7.0 | |
Performing a Version Upgrade from SQL Server 6.5 | |
Understanding System and User Databases | |
Understanding the Database Architecture | |
Understanding the Transaction Log Architecture | |
Understanding and Querying System and Database Catalogs | |
Creating and Configuring User Databases | |
Creating a User Database | |
Setting Database Options | |
Managing User Database Size Using Automatic File Growth Appropriately | |
Placing Database Files on Multiple Disks | |
Populating a Database | |
Transferring and Transforming Data | |
Introducing Microsoft Data Transformation Services (DTS) | |
Transferring and Transforming Data with DTS Graphical Tools | |
Working with DTS Packages | |
Using the Bulk Copy Program (Bcp) and the BULK INSERT Transact-SQL Statement | |
Developing a Data Restoration Strategy | |
Understanding Data Restoration Issues | |
Understanding the Types of Database Backups | |
Understanding the Restoration Process | |
Backing Up and Restoring SQL Server | |
Understanding Backup Terms, Media, and Devices | |
Backing Up Databases, Files, Filegroups, and Transaction Logs | |
Restoring a User Database | |
Restoring and Rebuilding System Databases | |
Managing Access to SQL Server 2000 | |
Understanding the Authentication Process | |
Understanding the Authorization Process | |
Creating and Managing Logins | |
Managing SQL Server Permissions | |
Granting Database-Specific Permissions | |
Using Application Roles | |
Designing an Access and Permissions Strategy | |
Performing Administrative Tasks | |
Performing Configuration Tasks | |
Setting Up Additional Features | |
Performing Maintenance Tasks | |
Automating Administrative Tasks | |
Defining Operators | |
Creating Jobs | |
Configuring Alerts | |
Creating a Database Maintenance Plan | |
Creating Multiserver Jobs | |
Monitoring SQL Server Performance and Activity | |
Developing a Performance Monitoring Methodology | |
Choosing Among Monitoring Tools | |
Performing Monitoring Tasks | |
Using SQL Server Replication | |
Introducing Replication | |
Planning for Replication | |
Implementing Replication | |
Mo | |
Table of Contents provided by Publisher. All Rights Reserved. |