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 ...

Get Microsoft® SQL Server® 2012 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.