Databases, Files, and Resource Management
Creating and managing databases, files, and their resources are required tasks for many administrators and developers working with SQL Server. Before many things can be accomplished with SQL Server, you must create a database to store database objects. In this chapter, we will focus on planning and creating new databases, understanding the options available for database creation, and maintaining databases and their resources on an ongoing basis.
In this chapter, you will learn to:
- Create new SQL Server databases
- Discover information about existing databases
- Manipulate database files and filegroups
- Take advantage of database snapshots
Planning a Database
Before we can do anything pertaining ...