How to move only the Veeam Enterprise Manager SQL Database to another Server

[WinstonWolf]

Hi ,
What are the steps when i want to move only the SQL Database from Veeam Enterprise Manager to our SQL Server ?

Thanks .

Michael

[rennerstefan]

Hi Michael,

Let us know if that page helps:
https://www.veeam.com/kb1889

It lists the different ways to do what you ask for.

Thanks

[WinstonWolf]

Try it like in the KB but i have Problems to take an Backup from the Database .
My User is not allowed to Backup the Database .
When i check Security Logins i see this :

[rennerstefan]

Hi again,
in my eyes you should be able to assign your user the access rights as needed in addition to the ones you already have!?
Thanks

[WinstonWolf]

No chance ,
Try to add my Admin to the Security Logins . But without success.

[rennerstefan]

is that with the built-in Veeam DB that comes with the installation or an external SQL Server?

[WinstonWolf]

It is the Build in SQL .
Yesterday i move the Veeam B&R Database to another SQL Server without any Problems over the dbconfig Tool . For this i dont need to logon in SQL Express himself .
But now for moving the SQL Database from Veeam Enterprise Manager i need to login in Management Studio and take there an Backup of the VeeamBackupReporting Database .

[rennerstefan]

can you please try it via PowerShell executing PowerShell as admin:
https://www.veeam.com/kb1471?ad=in-text-link

[WinstonWolf]

Hi ,
No chance . Because of missing Username or Password .

Is Veeam Enterprise Manager asking for an User for installing the SQL Database ?

I think i have to uninstall and reinstall the Enterprise Manager .

[rennerstefan]

I would recommend to open a case at our support to make sure everything is done right.
Feel free to share the case ID here as well.

[WinstonWolf]

I now do an fresh Install of Veeam Enterprise Server on an new Server .
Here the SQL Server Login rights looks so . Therefore i think something goes wrong on our original SQL Installation .

[WinstonWolf]

Is there something to think about when i want to reinstall the Enterprise Server without backup the Database ?

Michael

[rennerstefan]

Yes that screenshot looks much more what I would have expected.
Seems that the "old" one got cleaned and secured at some point from someone.

I guess you mean reinstalling it as a "fresh" installation without keeping any information of the current Enterprise manager.
First thing is to remember where the licensing was done as it may be the case that your Enterprise Manger was the central license point.
Of course, re-installing means you will loose all settings and history data of the EM as well.
What I would maybe do is to split the EM from the current server completely (so no re-installation on the current machine) and make it a own machine.
If you re-install on the same machine I doubt you will be succesfull as the registry Keys and install pathes etc may get you in an unstable state.
That said it is hard in the forum to give to definitive answers as I don't know the whole environment and all dependencies you may have, so no warranties from my side.
that's why I said a ticket could be good as well so you have the support team having a look.