MSSQL Server database

Destination
Common component
Plugin version
1.0.0
Supported Bacularis version
5.9.0 and greater
Documentation
Bug tracker
Last page update
2025-12-04 10:36 (3 days)

Description

The Bacularis plugin for MS SQL Server backup provides the following functionality:

  • Logical SQL database backups
  • Transaction log backups (WAL)
  • Point-in-Time Recovery (PITR)
  • Encryption data backups (Service Master Key, Database Master Keys, certificates …)
  • Backups of remote and local SQL Server instances
  • Backups of SQL Server instances on Windows
  • Backups of SQL Server instances on Linux
  • Restoring databases to the same or a different SQL Server instance

This plugin supports the following SQL Server database backup methods:

  • Dump backup method - also known as logical database backup. It creates backups in binary dump format. Two variants are available:
    • All databases backup - each database is stored in a separate dump file. This method allows restoring selected databases individually.
    • Selected databases dump - the Bacularis administrator specifies which databases to back up. This method also supports restoring selected individual databases.
  • Transaction log backup method - backs up the database transaction log.
  • Encryption data backup method - backs up selected encryption keys (Service Master Key, Database Master Key, certificates, asymmetric keys).

Installation

This plugin is already pre-installed in Bacularis and it does not require any additional installation.

Release notes for version 1.0.0

Changes:

  • Add new MSSQL Server database plugin