Abstract
In this chapter, you’ll see an assortment of recipes that revolve around creating and configuring a SQL Server database. Some of the things you’ll learn to do with Transact-SQL include the following:
-
Creating a new database
-
Adding or removing files or filegroups froma database
-
Viewing andmodifying database settings
-
Increasing or decreasing a database or database file size
-
Removing a database fromthe SQL Server instance
-
Detaching and reattaching a database froma SQL Server instance
I’ll also review the various “state” settings, such as configuring the database to be read-only, or putting the database into single-usermode.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2008 Joseph Sack
About this chapter
Cite this chapter
(2008). Creating and Configuring Databases. In: SQL Server 2008 Transact-SQL Recipes. Apress. https://doi.org/10.1007/978-1-4302-0625-5_22
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0625-5_22
Publisher Name: Apress
Print ISBN: 978-1-59059-980-8
Online ISBN: 978-1-4302-0625-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books