Configure SQL Service Recovery
| Previous Configure SQL Startup Parameters | Manual Configuration | Configure SQL Server Surface Area Next |
|---|
FineBuild can configure SQL Service startup options and the recovery actions to take is a service fails.
FineBuild exploits the Set Up Recovery Actions functionality within Windows to restart SQL Services if they fail. This provides a more sophisticated method of managing service restart than is provided within SQL Server Agent, and covers more services.
If SQL Agent was used to restart failed services, the SQL Agent service account would need Windows local Administrator authority. Because FineBuild uses Service Manager to control service recovery, the SQL Agent service account does not need local Administrator authority.
Automated silent Service Startup configuration relates to Process Id 5AG and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupServices: | Yes | Yes | N/A |
| SQL2017 | /SetupServices: | Yes | Yes | N/A |
| SQL2016 | /SetupServices: | Yes | Yes | N/A |
| SQL2014 | /SetupServices: | Yes | Yes | N/A |
| SQL2012 | /SetupServices: | Yes | Yes | N/A |
| SQL2008R2 | /SetupServices: | Yes | Yes | N/A |
| SQL2008 | /SetupServices: | Yes | Yes | N/A |
| SQL2005 | /SetupServices: | Yes | Yes | N/A |
In order to maintain compatibility with older versions of SQL FineBuild, the parameter /ConfigServices: can also be used.
The FineBuild SQL Service Recovery configuration includes the following:
-
Configure the following services to automatically restart if it fails up to 2 times in the same day. After a third failure the service will remain in stopped state
- SQL Server
- SQL Server Agent
- SQL Full-text Filter Daemon Launcher
- Analysis Services
- Integration Services
- Report Services
-
Set the start up mode for the following services to Manual
- SQL Server Active Directory Helper
- SQL Server VSS Writer
The following steps show what you would have to do for manual SQL Service Recovery configuration. FineBuild does all of this work for you automatically.
-
Right-click on My Computer and select Manage
Navigate to Services and scroll to the SQL Server services
Highlight the SQL Server (MSSQLSQLSERVER) service and select Properties. If a Named Instance has been installed, use the instance name in place of MSSQLSERVER in the service name.
-
Select the Recovery tab and set the following values
Action Response First Failure Restart the Service Second Failure Restart the Service Subsequent Failures Take No Action Reset fail count 1 (day) Restart service after 3 (minutes) 
-
Repeat the above step for the following services if they have been installed
If a Named Instance has been installed, use the instance name in place of MSSQLSERVER in the service name
- SQL Server Agent (MSSQLSERVER)
- SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
- SQL Server Analysis Services (MSSQLSERVER)
- SQL Server Integration Services
- SQL Server Reporting Services (MSSQLSERVER)
-
Highlight the SQL Server Active Directory Helper service
Select Properties and ensure Start up is set to Manual
-
Repeat the above process using the SQL Server VSS Writer service
Set Start up to Manual
The start up mode is controlled in FineBuild by the /WriterSVCStartupMode: parameter. This service should not be set to Disabled, as this will prevent Service Pack installation from working
-
Close the Computer Management window
-
Start the following services
If a given service is clustered, then start the service by putting the cluster group online. If the service is not clustered, then start it using a NET START command
- SQL Server
- SQL Server Agent.
- If Reporting Services is installed and is not configured as FilesOnlyMode, then start Reporting Services.
Copyright FineBuild Team © 2011 - 2020. License and Acknowledgements
| Previous Configure SQL Startup Parameters | Top | Configure SQL Server Surface Area Next |
|---|