SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Chapter 8

Creating SQL Server Databases

TOPICS COVERED IN THIS CHAPTER:

• SQL Server Databases
• Database Storage
• Database Options and Properties
• Creating Databases in the GUI
• Creating Databases with T-SQL
• Creating Databases with PowerShell
• Attaching and Detaching Databases
• Database Snapshots

The ultimate purpose of any SQL Server 2008 system is to provide data services. The services provided may be more advanced than simple database provisioning, but all SQL Server functions relate to data in one of several ways, including:

• Direct data access
• Data replication
• Reporting against data
• Analyzing data
• Data monitoring
• Creating data
• Providing data redundancy ...