← ClaudeAtlas

sqlbootstraplog-reviewlisted

Analyze SQL Server Setup Bootstrap log files to diagnose failed installations, failed Cumulative Update or Service Pack patching, failed cluster node operations, and risky setup-time configuration. Parses Summary.txt, Detail.txt, MSI/MSP logs, ConfigurationFile.ini, and SystemConfigurationCheck_Report content from the Setup Bootstrap Log folder. Applies 24 checks (U1–U24) covering final-result failure and exit-code extraction, failed setup rules (pending reboot, disk space, account permissions, prerequisites, cluster rules), Detail.txt exception forensics, MSI "Return value 3" patterns, and ConfigurationFile.ini review (service accounts, instant file initialization, TempDB layout, mixed authentication, feature sprawl, directory placement). Use this skill whenever SQL Server setup, an in-place upgrade, a patch, or add/remove node fails, or when a user pastes Summary.txt, Detail.txt, or ConfigurationFile.ini content.
vanterx/mssql-performance-skills · ★ 1 · API & Backend · score 77
Install: claude install-skill vanterx/mssql-performance-skills
# SQL Server Setup Bootstrap Log Review Skill ## Purpose Analyze SQL Server Setup Bootstrap log artifacts to find why an installation, upgrade, patch (CU/SP), repair, or cluster node operation failed — and to flag risky setup-time configuration before it becomes production drift. Applies 24 checks (U1–U24) across four categories: - **U1–U6** — Summary and outcome: final result failure, exit-code extraction, failed rules, partial feature failure, patch/upgrade per-instance failures, component update phase failures - **U7–U13** — Rule-failure patterns: pending reboot, disk space, account/permission, prerequisites, cluster rules, policy blockers, Global Rules phase - **U14–U18** — Detail.txt and MSI forensics: end-of-file exceptions, MSI "Return value 3", setup crashes, failure-chain root-cause ordering, Datastore state files - **U19–U24** — ConfigurationFile.ini review: service accounts, instant file initialization, TempDB layout, security surface, feature sprawl, directory placement Setup runs three phases — (1) Global Rules verification, (2) Component update, (3) the user-requested action — and writes a dated log folder per run. This skill is the installation-layer counterpart to `sqlerrorlog-review` (runtime) and `sqldbconfig-review` (post-install drift). ## Input Accept any of: - **Summary.txt** or `Summary_<MachineName>_<yyyyMMdd_HHmmss>.txt` — overall result, machine properties, discovered features, user input settings, detailed per-feature results, r