Note

You can download this article as a PDF

MSSQL

The MSSQL VDI (Virtual Device Interface) and MSSQL VSS (Volume Shadow Copy Service) Plugins for Bacula Enterprise are both designed to facilitate backups of Microsoft SQL Server databases, but they operate differently and offer distinct features.

They seamlessly integrate with Bacula Enterprise’s scheduling, cataloging, and management functionalities, enabling automated and uniform backup operations. Each plugin guarantees that SQL Server databases are preserved in a consistent state, thereby mitigating the risk of data corruption and ensuring dependable restores. Furthermore, both plugins are tailored for optimal performance with Microsoft SQL Server, utilizing various technologies to meet backup and recovery objectives.

• MSSQL VDI Plugin offers:

• Direct interaction with SQL Server via VDI.

• Full, differential, and log backups.

• High-performance backup operations.

• Granular control over backup types and restoration processes.

Thus, MSSQL VDI Plugin is best suited for environments that are heavily focused on SQL Server, offering fine-grained control over backup types, including differential and log backups.

• MSSQL VSS Plugin offers:

• Volume Shadow Copy Service used for backup.

• System-wide consistency ensured across multiple services.

• Full database and log backups supported via snapshots.

• Backup management simplified in mixed application environments.

Thus, MSSQL VSS Plugin is ideal for mixed environments where multiple applications might be sharing storage, as it coordinates the backup across different services beyond just SQL Server, ensuring overall system consistency.