# ⚠️ ÖNEMLİ: Registry yanlış silinirse sistem bozulabilir. Önce export al.
Write-Host "SQL Server tam temizleme başlatılıyor..." -ForegroundColor Cyan

# 1️⃣ Tüm SQL servislerini durdur
$services = @(
    "MSSQLSERVER",
    "SQLSERVERAGENT",
    "SQLTELEMETRY",
    "MSSQL$MIKROSQL",
    "MSSQL$SQLEXPRESS",
    "SQLAgent$MIKROSQL",
    "SQLAgent$SQLEXPRESS",
    "SQLTELEMETRY$MIKROSQL",
    "SQLTELEMETRY$SQLEXPRESS",
    "SQLBrowser"
)

foreach ($s in $services) {
    if (Get-Service -Name $s -ErrorAction SilentlyContinue) {
        Write-Host "Durduruluyor: $s"
        Stop-Service -Name $s -Force -ErrorAction SilentlyContinue
    }
}

# 2️⃣ Klasörleri topluca sil
$paths = @(
    "$env:ProgramFiles\Microsoft SQL Server",
    "$env:ProgramFiles(x86)\Microsoft SQL Server",
    "$env:ProgramData\Microsoft\SQL Server",
    "$env:TEMP\*"
)

foreach ($p in $paths) {
    if (Test-Path $p) {
        Write-Host "Siliniyor: $p"
        Remove-Item $p -Recurse -Force -ErrorAction SilentlyContinue
    }
}

# 3️⃣ Registry Temizliği (Default + Named instance)
$regPaths = @(
    "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server",
    "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL",
    "HKLM:\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server",
    "HKLM:\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server\Instance Names\SQL",
    "HKLM:\SYSTEM\CurrentControlSet\Services\MSSQLSERVER",
    "HKLM:\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT",
    "HKLM:\SYSTEM\CurrentControlSet\Services\SQLTELEMETRY",
    "HKLM:\SYSTEM\CurrentControlSet\Services\MSSQL$MIKROSQL",
    "HKLM:\SYSTEM\CurrentControlSet\Services\MSSQL$SQLEXPRESS",
    "HKLM:\SYSTEM\CurrentControlSet\Services\SQLAgent$MIKROSQL",
    "HKLM:\SYSTEM\CurrentControlSet\Services\SQLAgent$SQLEXPRESS",
    "HKLM:\SYSTEM\CurrentControlSet\Services\SQLTELEMETRY$MIKROSQL",
    "HKLM:\SYSTEM\CurrentControlSet\Services\SQLTELEMETRY$SQLEXPRESS",
    "HKLM:\SYSTEM\CurrentControlSet\Services\SQLBrowser"
)

foreach ($r in $regPaths) {
    if (Test-Path $r) {
        Write-Host "Registry Siliniyor: $r"
        Remove-Item $r -Recurse -Force -ErrorAction SilentlyContinue
    }
}

Write-Host "✅ Tüm SQL Server instance ve servis kalıntıları temizlendi." -ForegroundColor Green
Write-Host "`nNot: Eğer Windows Installer bozuk kayıt hataları devam ederse, Microsoft Fix Tool kullanın:" -ForegroundColor Yellow
Write-Host "https://support.microsoft.com/mats/program_install_and_uninstall" -ForegroundColor Yellow
Write-Host "`nBilgisayarı restart edip SQL Server 2022 setup’ını yönetici olarak çalıştırabilirsiniz." -ForegroundColor Cyan