microsoft / microsoft/sql-server-samples

Invoke-SqlAssessment - for trace flag 3226 is not working as expected.

Open Beginner friendly
#1,341 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
PowerShell
Stars
11.2k
Forks
9.1k
Avg merge
2d 7h
Merged PRs (30d)
14

Description

This check give you an alert if trace flag 3226 is enabled but it should be the opposite.
It says "Disable trace flag 3226 to prevent SQL Server from recording ErrorLog entries for each successful backup operation"
while it should be "Enable trace flag 3226 to prevent SQL Server from recording ErrorLog entries for each successful backup operation"

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start at the Invoke-SqlAssessment check for trace flag 3226 and inspect the message shown in the issue. Correct the recommendation so it says to enable the trace flag, then run the assessment check to verify that the alert wording is accurate.

Written by the indexing model from the issue text.

Assessment

Tech stack
powershell
Domain
databases
Issue type
Bug
Difficulty
1/5
Estimated time
Under an hour
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
62/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.