Host-based backup of VMware vSphere VMs.
Post Reply
KevinDetron
Novice
Posts: 9
Liked: never
Joined: Mar 30, 2023 3:23 pm
Contact:

Cant migrate Enterprise Manager from MSSQL to PostgreSQL

Post by KevinDetron »

Hi,

I'm trying to migrate our Veeam environment to PostgreSQL. I upgraded the Enterprise Manager and B&R servers to v12.1.1.56 first.

But when trying to create a backup of the Enterprise Manager database it fails and specifies it can't write to the file.
The disk is large enough. I ran a repair of Enterprise Manager which has not solved the issue. A file gets created at the specified path, but error message "Unable to write to configuration backup file." appears.

Veeam One has been installed on the same server in the past, but I have uninstalled it and reinstalled Enterprise Manager. I read here that it might cause issues? veeam-backup-replication-f2/failed-conf ... 91680.html

Code: Select all

PS D:\program files\veeam\Backup and Replication\Enterprise Manager> .\Veeam.EM.DB.Migration.exe /file:"C:\tmp\BEMConf.emco" /backupemdatabase /encryptionpassword:1l0v3KB5 /encryptionhint:bestpassever
Veeam EM DB Migration Version 12.1.0.0
Copyright (C) 2006-2024 Veeam Software Group GmbH
Keep in mind the following compatibility limitations:
1. Veeam Backup Enterprise Manager with a PostgreSQL based configuration database will not be able to manage backup servers with a Microsoft SQL Server based configuration database. Migrate all your backup servers to PostgreSQL prior to migrating Veeam Backup Enterprise Manager to same.
2. Veeam Backup Enterprise Manager migration utility supports one way migration from Microsoft SQL Server to PostgreSQL only. Migration from PostgreSQL to Microsoft SQL Server is not currently supported.

For more details, please refer to the Veeam Backup Enterprise Manager Help Center.
    Backing up entry configuration.xml...
Back▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
Unable to write to configuration backup file.
Mildur
Product Manager
Posts: 10086
Liked: 2688 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Cant migratie Enterprise Manager to PostgreSQL

Post by Mildur »

Hello Kevin,

That sounds like a technical issue. We cannot investigate such issues through a forum topic.
Please provide a support case ID for this issue, as requested when you click New Topic. Without case number, the topic will eventually be deleted by moderators.

Before you contact our support team, try the following options:
- Run Veeam.EM.DB.Migration.exe in an administrator prompt
- Use different folder for the export.

Best regards,
Fabian
Product Management Analyst @ Veeam Software
KevinDetron
Novice
Posts: 9
Liked: never
Joined: Mar 30, 2023 3:23 pm
Contact:

Re: Cant migrate Enterprise Manager from MSSQL to PostgreSQL

Post by KevinDetron »

Support case ID: # 07263965
Mildur
Product Manager
Posts: 10086
Liked: 2688 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Cant migrate Enterprise Manager from MSSQL to PostgreSQL

Post by Mildur »

Hi Kevin

I can see in the case notes that our support team found an issue with a database entry in the notification settings.
We have a few other cases with the same issue. Disabling mail notification before doing the database migration solved it for those customers.

Best,
Fabian
Product Management Analyst @ Veeam Software
Post Reply

Who is online

Users browsing this forum: Baidu [Spider] and 33 guests