SQL Servero System Administration. About the Authors. About the Technical Reviewers. Dedications. Acknowledgments. Tell Us What You Think!
I. SETUP AND CONFIGURATION.
1. Setup: Troubleshooting and Advanced Topics. Troubleshooting Setup Problems. Automated Setup. Character Sets and Sort Orders. Sizing the Master Database. Upgrading from Previous Versions of SQL Server. All About Autoconfiguration. Setting Up Client Utilities. Conclusions.
2. Connectivity and Network Configuration. Server-Side Networking. Client-Side Networking. Configuring ODBC. Examining OLE-DB. Conclusions.
3. Security and Licensing. Security Philosophy. What to Secure and Why. Cost Justification. The SQL Server 7.0 Security Model. Implementing an Effective Security Model. Troubleshooting Security Problems. Licensing Issues. Conclusions.
II. DAY-TO-DAY MAINTENANCE.
4. Storage Management. Internal Structures. External Storage: Files and File Groups. Optimizing Storage. Conclusions.
5. The SQL Agent. Introducing the SQL Agent. Configuring SQL Mail. Configuring the SQL Agent. Adding Operators. Configuring Jobs. Configuring Alerts. Setting Up a Master Server (MSX). Case Studies. Conclusions.
6. Backup and Recovery. How Backup Works. Configuring Automatic Backup. Backup Strategies. Backup Recommendations. Disaster Recovery. Third-Party Backup Utilities. Conclusions.
7. Database Maintenance. Preventive Maintenance. Maintaining Performance. Proactive Maintenance with the Database Maintenance Plan Wizard. Recommendations. Conclusions.
III. LESS FREQUENT ACTIVITIES.
8. Data Import/Export. Exploring Transfer Methods. Using BCP and BULK INSERT. Using Distributed Queries. Using Data Transformation Services (DTS). Conclusions.
9. Replication. Top Features. Setup and Configuration. Replication Agents. Snapshot Replication. Transactional Replication. The Immediate Updating Subscribers Option of Snapshot and Transactional Replication. Merge Replication. Replication and the New SQL Server Security Roles. Subscribing. Monitoring Replication. Advanced Replication Topics. Conclusions.
10. Achieving High Availability. Redundant Hardware. Warm Spares. Clustering. Conclusions.
11. Performance Tuning and Optimization. How to Best Use This Chapter. PT&O Theory. Tools for Monitoring SQL Server and Windows NT. Tracking Down a Performance Problem. Application Optimization Strategies. Server Optimization Strategies. Conclusions.
Index.