- What's New for Installation with SQL Server 2008?
- Preplanning and Preparing a SQL Server 2008 Server Database Engine Installation
- Gathering Additional Information Necessary to Proceed
- Installing a Clean Version of SQL Server 2008
- Upgrading the Database Engine to SQL Server 2008
- Finalizing the SQL Server 2008 Installation or Upgrade
- Managing SQL Server 2008 Installations
- Best Practices
This chapter is from the book
The following are best practices from this chapter:
- Verify that your hardware, devices, and drivers are supported by SQL Server 2008.
- Stick to using the recommended or optimal hardware and software requirements when installing or upgrading to SQL Server 2008.
- Leverage the planning tools and documentation associated with the SQL Server Installation Center when installing or upgrading to SQL Server 2008.
- Run the System Configuration Checker tool as a prerequisite task when either installing or upgrading to SQL Server 2008.
- Install and run the Upgrade Advisor to identify any upgrade anomalies when upgrading a system to SQL Server 2008.
- When performing an upgrade, make sure you document your SQL Server system and database configuration information and perform a backup of any SQL Server data and objects that you want to keep.
- Leverage Windows Server 2008 as the operating system when running SQL Server 2008.
- Finalize a SQL Server implementation by hardening the system based on the best practices listed in Chapter 8.
- Because the SAC tool has been deprecated, utilize Policy Based Management to configure the surface area of one or many SQL Server systems.
- The Windows Server 2008 Advanced Firewall is enabled by default; therefore, review Chapter 8 to understand how to configure the firewall for SQL Server access.
- Review Books Online if you need to upgrade other SQL Server 2008 features above and beyond the Database Engine.
- Data, log, and tempdb directories should be on separate physical disks or Logical Unit Numbers (LUNs) for performance whenever possible.