1. Home
  2. SQL
  3. Microsoft SQL Server 2000

Chapter 11. Creating and Managing Databases

By Paul Jensen and Ray Rankins

IN THIS CHAPTER

  • What Makes Up a SQL Server Database?

  • Data Storage in SQL Server

  • Database Files

  • Creating Databases

  • Managing Databases

  • Setting Database Options

The database is, of course, SQL Server's sole reason for existence. This chapter will examine what a database consists of, how to create one, and the ongoing management requirements of a database.



    		Part I: Welcome to Microsoft SQL Server
    		Part II: SQL Server Tools and Utilities
    		Part III: SQL Server Administration
    		Chapter 8. Installing and Upgrading SQL Server
    		Chapter 9. Client Installation and Configuration
    		Chapter 10. SQL Server System and Database Administration
    		Chapter 11. Creating and Managing Databases
    		What Makes Up a SQL Server Database?
    		Data Storage in SQL Server
    		Database Files
    		Creating Databases
    		Managing Databases
    		Setting Database Options
    		Summary
    		Chapter 12. Creating and Managing Tables in SQL Server
    		Chapter 13. Creating and Managing Indexes
    		Chapter 14. Implementing Data Integrity
    		Chapter 15. Security and User Administration
    		Chapter 16. Database Backup and Restore
    		Chapter 17. Database Maintenance
    		Chapter 18. SQL Server Scheduling and Notification
    		Chapter 19. Managing Linked and Remote Servers
    		Chapter 20. Importing and Exporting SQL Server Data Using BCP and DTS
    		Chapter 21. Administering Very Large SQL Server Databases
    		Chapter 22. Data Replication
    		Chapter 23. SQL Mail
    		Chapter 24. SQL Server Clustering
    		Chapter 25. Defining System Administration and Naming Standards
    		Part IV: Transact-SQL
    		Part V: SQL Server Internals and Performance Tuning
    		Part VI: Additional SQL Server Features