Chapter 4. Creating Databases
After completing this chapter, you will be able to
Understand the function of each system database
Create databases
Define and add filegroups to a database
Add files to a filegroup
Detach and attach databases
Databases are the primary objects within SQL Server for both the relational engine as well as SQL Server 2008 Analysis Services (SSAS). In this chapter, you will learn how to create databases along with the fundamentals of data storage. You will learn about the different types of filegroups that can be created for a database and how each type affects the way data is stored and handled.
Since all data within SQL Server has to be stored inside a database, information about the SQL Server instance and any objects that ...
Get Microsoft® SQL Server® 2008 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
