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

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

Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial