Large Scale Deployment Using SQL FineBuild

Previous SQL Server Always On Install	Site Level Default Values Next

One of the strengths of SQL FineBuild is the ability to deploy standardised builds of SQL Server to a large number of machines. This section describes how these deployments can be done.

When SQL Server is deployed on to a number of servers, the best practice is to identify a set of server roles and store these details in a Site SQL Files Folder.

The servers that form a given role should all be built in the same way. Each organisation will have its own unique server roles, and the examples below show some roles that can be adapted as required. Each role file would contain the FineBuild parameters that define the role, so that all servers in a given role can be built with the same configuration.

In addition to the role file, a separate install file will normally be created for each SQL instance that is to be installed, which would also be stored in the Site SQL Files Folder. As shown by the Developer Workstation Role, it is useful to be pragmatic about when separate files for each SQL instance are used, compared to running the role file directly.

Details of the parameters used in the Role Files are given in FineBuild Parameter Inventory. Site-specific items can be configured automatically by SQL FineBuild, see AutoConfig Processing for details.

Item	Comment
	Role Files
Site Level Default Values	Parameter values that should be applied to all SQL FineBuild installs
Workhorse Server Role	Standard server role for deployment on high-end hardware
Lightweight Server Role	Standard server role for deployment on low-end hardware
Legacy Server Build	Special server build for old version of SQL Server
Management Server Role	The Master host role for Master/Target components
Developer Workstation Role	Workstation role for deployment on desktop hardware
Administration Server Role	Client role, for DBA Administration purposes
	Other Deployment Items
Installing SQL Server on Windows Core	Limitations when installing SQL Server on Windows Server Core
Install SQL Server Using Altiris	Using SQL FineBuild with a deployment tool

Copyright FineBuild Team © 2014 - 2021. License and Acknowledgements

Previous SQL Server Always On Install	Top	Site Level Default Values Next