Large Scale Deployment Overview

Previous Connection String Stability	Site SQL Files Folder Next

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 organisation should also use separate Development, Test and Production Environments.

This section of Large Scale Deployment Using SQL FineBuild will focus on building the deployment process. The SQL Server Deployment Architecture section will focus on the overall architecture that can be used.

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.

Copyright FineBuild Team © 2021. License and Acknowledgements

Previous Connection String Stability	Top	Site SQL Files Folder Next