Chapter 2. SQL Server 2008 Installation Best Practices

SQL Server is relatively easy to install. You can put the CD or DVD into the drive, in most cases click straight though, and you'll get a running, useful install. Several decisions are made by default as you click through, however. In this chapter, you learn about those decisions and discover the related gotchas and how to avoid them.

The core installation process follows these general steps:

  • Plan the system.

  • Get the hardware and software.

  • Install the operating system and service packs.

  • Set up the I/O subsystem.

  • Install SQL Server and service packs.

  • Burn in the system.

  • Do post-install configurations if necessary.

  • Clean up for deployment and go!

This chapter focuses on the plan and the actual install.

Get Professional Microsoft® SQL Server® 2008 Administration 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.