Chapter 16. SQL Server Installation
In Chapter 15, we built an inventory consisting of SQL Server instances and their hosts. What should you do to ensure that every server in our inventory is available to users and applications that use it? How do you maintain a stable and high-performance database environment? How do you ensure that in cases of hardware or software failures, you will be able to recover the databases in a timely fashion to meet the SLA? These are all responsibilities of the database administrator (DBA).
In this chapter, we focus on the first DBA responsibility in the life cycle of a SQL Server instance: SQL Server installation. Our approach simplifies the massive installation of tens or hundreds of servers. It will help alleviate the workload in a great deal in enterprise environments, where one or more servers are built every week.
This chapter covers the following topics:
Installation procedure and template
Standalone installation example
Cluster installation example
Installation Procedure and Template
If you are installing one or more SQL servers per week, it would be worthwhile to consider automating the process. Automation makes the life of a DBA much easier. It simplifies the installation process and minimizes human error. If your organization has standards for SQL Server installation, you can enforce them in the installation scripts.
Installation binaries of SQL Server have evolved drastically. The command-line-based installation has evolved from SetupSQL.exe with ...
Get Microsoft® SQL Server® 2008 Administration with Windows PowerShell™ 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.
