Course work: the discipline Databases. Subject: Administration of MS SQL Server 2000.

Course work: the discipline Databases. Subject: Administration of MS SQL Server 2000.

TABLE OF CONTENTS

INTRODUCTION
1. ADMINISTRATION
1.1 The operation of SQL Server 2000
1.2 Configuring SQL Server 2000
1.2.1 Configuring the service MSSQLServer
1.2.2 Configuring the SQLServerAgent service
1.3 Security SQL Server 2000
1.3.1 Security at the server level
1.3.2 System-level security database
1.4 Import, export, and transform data
1.5 Automating Administration
1.6 Backing up databases
1.7 Data Replication
1.8 Monitoring the performance and activity of SQL Server
1.9 Creating a fault-tolerant system
CONCLUSION
REFERENCES