Summary
This chapter focused heavily on how to explore, create, and recover databases. In the area of exploring databases, the chapter covered system catalog views and selected stored procedures. sys.databases was the main catalog view covered in the chapter, but sys.tables and sys.columns were also given some attention. The system-stored procedures for learning about and manipulating databases covered here included sp_helpdb and sp_dboption. The review of creating databases focused on programmatic approaches; see Chapter 2 for a demonstration of graphical techniques for creating databases. This chapter illustrated how to create and manipulate databases programmatically with Express SSMS. You were also able to take a close look at the CREATE DATABASE statement from multiple perspectives, including creating a database from scratch as well as attaching data and log files copied from databases that already exist. The chapter’s final major section drilled down on backing up and restoring databases. You learned core concepts and saw specific examples that illustrated how to build backup and restore solutions with the BACKUP DATABASE and RESTORE DATABASE statements.
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
© 2006 Rick Dobson
About this chapter
Cite this chapter
(2006). Exploring, Creating, and Recovering Databases. In: Beginning SQL Server 2005 Express Database Applications. Apress. https://doi.org/10.1007/978-1-4302-0108-3_3
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0108-3_3
Publisher Name: Apress
Print ISBN: 978-1-59059-523-7
Online ISBN: 978-1-4302-0108-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books