This project has moved. For the latest updates, please go here.

Previous Configure SQL Startup Parameters Manual Configuration Configure SQL Server Surface Area Next

Configure SQL Service Recovery

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.

FineBuild SQL Service Recovery configuration

Automated silent Service Startup configuration relates to Process Id 5AE and is controlled by the parameters below:

Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014 SQL2016 SQL2017
SetupServices FULL Yes Yes Yes Yes Yes Yes Yes
SetupServices WORKSTATION Yes Yes Yes Yes Yes Yes Yes
SetupServices CLIENT N/A N/A N/A N/A N/A N/A 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
Top

Manual SQL Service Recovery configuration

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.

1) 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.
ComputerManagerSelect.png
2) Select the Recovery tab and set the following values:

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)

ServiceProperties.png
3) 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)
4) Highlight the SQL Server Active Directory Helper service, select Properties, and ensure Start up is set to Manual.
ServiceStartup.png
5) Repeat the above process using the SQL Server VSS Writer service and 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.
6) Close the Computer Management window.

7) 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 - 2017. License and Acknowledgements
Previous Configure SQL Startup Parameters Top Configure SQL Server Surface Area Next

Last edited Jan 6 at 3:58 PM by EdVassie, version 4