O'Reilly logo

Microsoft® SQL Server® 2008 Bible by Uttam Parui, Mike White, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Installing SQL Server 2008

IN THIS CHAPTER

  • Server-hardware recommendations

  • Planning an installation

  • Installing multiple instances of SQL Server

  • Upgrading from previous versions of SQL Server

  • Migrating to SQL Server

The actual process of installing SQL Server is relatively easy; the trick is planning and configuring the server to meet the current and future needs of a production environment—planning the hardware, selecting the operating system, choosing the collation, and several other decisions should be settled prior to the SQL Server installation.

Not every SQL Server 2008 server will be a fresh installation. SQL Server 2000 and SQL Server 2005 servers can be upgraded to SQL Server 2008. Additionally, the data might reside in a foreign database, such as Microsoft Access, MySQL, or Oracle, and the project might involve porting the database to SQL Server.

Not every SQL Server 2008 server will run production databases—there are developer sandbox servers, quality test servers, integration test servers, performance test servers, and the list goes on. This chapter discusses all these situations to help you avoid surprises.

Selecting Server Hardware

The value per dollar for hardware has improved significantly and continues to do so. Nevertheless, large datacenters can still cost hundreds of thousands of dollars. This section provides some design guidelines for planning a server.

CPU planning

SQL Server needs plenty of raw CPU horsepower. Fortunately, the newer crop of CPUs perform very ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required