Azacsnap Configure 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

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	Status	Result
2025-07-12 23:44	#41	cancelled	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