Automated recovery mechanism for SQL Server services after Windows startup, patching, or server reboot scenarios.
This PowerShell solution creates a Windows Scheduled Task that validates and starts SQL Server Database Engine and SQL Server Agent services after system boot. The task runs automatically as the SYSTEM account with elevated privileges and provides an additional recovery layer for environments where SQL Server services may fail to start during the normal Windows startup sequence.
The automation addresses a well-known scenario where SQL Server Agent cannot start because the SQL Server Database Engine is not yet fully available during operating system startup. In heavily loaded systems, virtualized environments, clustered deployments, or after patch installation, service dependency timing issues can prevent SQL Server Agent from initializing correctly. Microsoft documents this behavior as a startup sequencing issue where SQL Server Agent may fail because the SQL Server service is unavailable or not fully initialized. Microsoft SQL Server
Instead of requiring manual intervention after every reboot, the scheduled task performs a controlled validation of service status and starts the required services only when necessary.
Why This Is Needed
When a Windows server restarts:
- Windows attempts to start SQL Server services.
- SQL Server Database Engine may require additional time to initialize.
- SQL Server Agent depends on the Database Engine.
- Agent startup may fail if the Engine is not yet available.
- Scheduled jobs, maintenance plans, backups, monitoring, and alerts remain unavailable until Agent is manually started.
This solution provides a delayed validation process that runs after boot, verifies service status, and starts SQL Server services when required.
Key Capabilities
- Automatic execution after Windows startup
- Delayed startup validation to avoid service timing issues
- SQL Server Engine status verification
- SQL Server Agent status verification
- Automatic recovery of stopped services
- SYSTEM account execution with highest privileges
- Safe operation without generating unnecessary errors
- Support for named SQL Server instances
- Suitable for patching and maintenance reboot scenarios
Functions Performed
- Removes any previous version of the scheduled task.
- Creates a dedicated SQL Server task folder.
- Creates a startup-triggered scheduled task.
- Waits for the configured startup delay period.
- Verifies SQL Server Database Engine status.
- Starts the Engine service if required.
- Re-validates service state.
- Starts SQL Server Agent when the Engine becomes available.
- Executes using the local SYSTEM account.
- Runs automatically after every reboot.
Benefits
- Prevents SQL Server Agent startup failures after reboot.
- Eliminates manual service recovery activities.
- Ensures scheduled jobs become available automatically.
- Reduces operational support effort.
- Improves SQL Server availability after maintenance windows.
- Provides consistent service startup behavior across environments.
