Backup Azure Sql Database - Document Details

About This Page

This page is part of the Azure documentation. It contains code examples and configuration instructions for working with Azure services.

View on GitHub 📚 View on Microsoft Learn

Bias Analysis

Detected Bias Types

windows_first

powershell_heavy

windows_tools

missing_linux_example

Summary

The documentation is heavily biased towards Windows environments. All examples, instructions, and tooling references are Windows-centric, including exclusive use of Windows service accounts, PowerShell scripts, Windows file paths, and SSMS (SQL Server Management Studio). There is no mention of Linux-based SQL Server VMs, nor any Linux-specific instructions or parity for backup configuration, permissions, or troubleshooting.

Recommendations

Add explicit support and instructions for SQL Server on Linux VMs, including any differences in extension installation, service accounts, and permissions.
Provide Linux command-line examples (e.g., Bash scripts, use of sqlcmd on Linux) alongside PowerShell examples.
Document the location of configuration files and logs for Linux-based SQL Server VMs.
Clarify whether the AzureBackupWindowsWorkload extension or an equivalent is available for Linux, and if not, state the limitation clearly.
Include troubleshooting steps and permission-setting instructions for Linux environments (e.g., using chown/chmod, systemd service accounts).
Ensure that all file path examples are provided in both Windows and Linux formats where applicable.

Create Pull Request

Scan History

Date	Scan	Status	Result
2026-01-22 00:00	#153	completed	Biased
2026-01-12 00:00	#99	completed	Biased
2026-01-11 06:20	#98	completed	Biased
2026-01-10 00:00	#92	completed	Biased
2026-01-06 22:28	#78	completed	Clean
2025-12-29 18:00	#48	cancelled	Biased
2025-12-15 00:00	#7	completed	Clean
2025-12-14 05:05	#6	completed	Clean

Flagged Code Snippets

   $cred = Get-Credential
   New-SmbGlobalMapping -RemotePath <FileSharePath> -Credential $cred -LocalPath <LocalDrive>:  -FullAccess @("<Comma Separated list of accounts>") -Persistent $true

param(
    [Parameter(Mandatory=$false)]
    [string] $InstanceName = "MSSQLSERVER"
)
if ($InstanceName -eq "MSSQLSERVER")
{
    $fullInstance = $env:COMPUTERNAME   # In case it is the default SQL Server Instance
}
else
{
    $fullInstance = $env:COMPUTERNAME + "\" + $InstanceName   # In case of named instance
}
try
{
    sqlcmd.exe -S $fullInstance -Q "sp_addsrvrolemember 'NT Service\AzureWLBackupPluginSvc', 'sysadmin'" # Adds login with sysadmin permission if already not available
}
catch
{
    Write-Host "An error occurred:"
    Write-Host $_.Exception|format-list -force
}
try
{
    sqlcmd.exe -S $fullInstance -Q "sp_addsrvrolemember 'NT AUTHORITY\SYSTEM', 'sysadmin'" # Adds login with sysadmin permission if already not available
}
catch
{
    Write-Host "An error occurred:"
    Write-Host $_.Exception|format-list -force
}

     {
        "EnableLocalDiskBackupForBackupTypes": ["Log"],
        "LocalDiskBackupFolderPath": "E:\\LocalBackup",
     }

   $cred = Get-Credential
   New-SmbGlobalMapping -RemotePath \\i00601p1imsa01.file.core.windows.net\rsvshare -Credential $cred -LocalPath Y:  -FullAccess @("NT AUTHORITY\SYSTEM","NT Service\AzureWLBackupPluginSvc") -Persistent $true