Document Details
Azacsnap Configure Database
❌
This page contains Windows bias
About This Page
This page is part of the Azure documentation. It contains code examples and configuration instructions for working with Azure services.
Bias Analysis
Bias Types:
⚠️
windows_first
⚠️
windows_tools
⚠️
powershell_heavy
Summary:
The documentation provides detailed, parity-rich instructions for SAP HANA, Oracle, and IBM Db2, all using Linux-native tools and shell commands. However, the Microsoft SQL Server section is Windows-centric, referencing only Windows executables (e.g., .\azacsnap.exe), and assumes a Windows environment without offering Linux alternatives or parity. The SQL Server section also appears last, but its instructions are Windows-specific, and there are no PowerShell or Windows command examples for the other databases, indicating a bias toward Windows for SQL Server scenarios.
Recommendations:
- Add explicit instructions and examples for running AzAcSnap with Microsoft SQL Server on Linux (e.g., SQL Server on Linux, using azacsnap as a Linux binary, and connecting via sqlcmd or other Linux tools).
- Provide both Windows and Linux command-line examples for Microsoft SQL Server, including shell and PowerShell where appropriate.
- Clarify in the prerequisites and installation sections whether AzAcSnap supports SQL Server on Linux, and if so, provide parity in setup, configuration, and testing steps.
- Where Windows-specific tools or paths are mentioned (e.g., .\azacsnap.exe), also show the Linux equivalent (e.g., ./azacsnap) to ensure cross-platform clarity.
- Consider reordering or grouping instructions so that Linux and Windows environments are treated equally for all supported databases.
Create pull request
Scan History
| Date | Scan ID | Status | Bias Status |
|---|---|---|---|
| 2025-07-12 23:44 | #41 | in_progress | ❌ Biased |
| 2025-07-12 00:58 | #8 | cancelled | ✅ Clean |
| 2025-07-10 05:06 | #7 | processing | ✅ Clean |
Flagged Code Snippets
Get the contents of the public key:
# [Microsoft SQL Server](#tab/mssql)
The snapshot tools issue commands to the Microsoft SQL Server database directly to enable and disable backup mode.
AzAcSnap connects directly to Microsoft SQL Server using the provided connect-string to issue SQL commands, such as `ALTER SERVER CONFIGURATION SET SUSPEND_FOR_SNAPSHOT_BACKUP = ON` or `ALTER SERVER CONFIGURATION SET SUSPEND_FOR_SNAPSHOT_BACKUP = OFF`. The connect-string will determine if the installation is on the database server or a centralized "backup" server. Typical installations of AzAcSnap would be onto the database server to ensure features such as flushing file buffers can work as expected. If AzAcSnap has been installed onto the database server, then be sure the user running azacsnap has the required permissions.
##### `azacsnap` user permissions
Refer to [Get started with Azure Application Consistent Snapshot tool](azacsnap-get-started.md)
The `azacsnap` user should have permissions to put Microsoft SQL Server into backup mode, and have permissions to flush I/O buffers to the volumes configured.
Configure (`.\azacsnap.exe -c configure`) with the correct values for Microsoft SQL Server and test (`.\azacsnap.exe -c test --test mssql`) azacsnap database connectivity.
Run the `azacsnap` test command