Chapter 4. Designing SQL Server databases
After completing this chapter, you will be able to
Understand the requirements and functions of each system database.
Understand the SQL Server database structure.
Create a database.
Add and alter filegroups.
Add files to filegroups.
Detach and attach databases.
Understand database recovery models.
The database is the container for all objects within Microsoft SQL Server for the relational engine. In this chapter, you will learn about the system databases that store vital information about the SQL Server instance. You will also learn fundamental techniques needed to create user-defined databases, along with methods you can use to control how and where data is stored. The methods include creating databases that ...
Get Microsoft® SQL Server® 2012 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.
