IN THIS CHAPTER
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.
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.
SQL Server needs plenty of raw CPU horsepower. Fortunately, the newer crop of CPUs perform very ...