Get‑SqlDscSetupLog - dsccommunity/SqlServerDsc GitHub Wiki

Get SQL Server setup bootstrap log.

Get-SqlDscSetupLog [[-Path] <String>] [<CommonParameters>]

This command retrieves the SQL Server setup bootstrap log (Summary.txt) from the most recent setup operation. The log is typically located in the Setup Bootstrap\Log directory under the SQL Server installation path.

This command is useful for diagnosing SQL Server setup failures or understanding what occurred during the installation, upgrade, or rebuild operations.

Get-SqlDscSetupLog

Retrieves the most recent SQL Server setup log from the default location.

Get-SqlDscSetupLog -Path 'D:\SQLServer'

Retrieves the most recent SQL Server setup log from a custom installation path.

Get-SqlDscSetupLog -Verbose | Select-String -Pattern 'Error'

Retrieves the setup log and filters for lines containing 'Error'.

Specifies the root SQL Server installation path to search for the setup log file. Defaults to 'C:\Program Files\Microsoft SQL Server'.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 1
Default value: C:\Program Files\Microsoft SQL Server
Accept pipeline input: False
Accept wildcard characters: False

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.