Operational Defect Database

BugZero found this defect 400 days ago.

Veeam | kb4409

How to Migrate Veeam Backup Enterprise Manager's Database from Microsoft SQL to PostgreSQL

Last update date:

1/5/2024

Affected products:

Veeam Backup & Replication

Affected releases:

12.1

Fixed releases:

No fixed releases provided.

Description:

Purpose

This article documents migrating the Veeam Backup Enterprise Manager (Enterprise Manager) configuration database from Microsoft SQL to PostgreSQL. Notes: The migration process is one-way only. Migration can only be performed from Microsoft SQL to PostgreSQL. The database engine used by the Veeam Backup Enterprise Manager and all of the Veeam Backup & Replication Servers managed by that Veeam Backup Enterprise Manager must match. Any mismatch in the database engine will cause the Database Replication task to fail with either: Veeam Backup Enterprise Manager with Microsoft SQL Server configuration database does not support the management of backup servers using PostgreSQL. or Veeam Backup Enterprise Manager with PostgreSQL configuration database does not support the management of backup servers using Microsoft SQL Server. Migration from Microsoft SQL to PostgreSQL is only possible for Veeam Backup Enterprise Manager running version 12 or newer.

Requirements

This procedure requires the following: The Veeam Backup Enterprise Manager database must presently be using Microsoft SQL. An existing PostgreSQL instance must be available for the database to be moved to, either local to the Veeam Backup Enterprise Manager software or remote.

Solution

Part 1: Back up the Current Veeam Backup Enterprise Manager Database Open an Administrative Command Prompt Navigate to the Veeam Backup Enterprise Manager install folder:

Additional Resources / Links

Share:

BugZero® Risk Score

What's this?

Coming soon

Status

Solved

cost-cta-background

Do you know how much operational outages are costing you?

Understand the cost to your business and how BugZero can help you reduce those costs.

Have you ever...

had your data corrupted from a

VMware

bug?

Search:

...