Comprehensive data protection for all workloads
Post Reply
denit
Service Provider
Posts: 21
Liked: never
Joined: Oct 07, 2016 1:58 pm
Full Name: Denit Support
Location: the Netherlands
Contact:

Way to find the right SQL database in Veeam?

Post by denit »

Is there a way to find the right underlying database that Veeam uses?

I want to make a backup of the configuration database before i upgrade from version 9 to 9.5
However, i run into the issue that i cannot discover which database is actually the configuration database.
We run SQL2008 R2 and there are more databases that contain the name "veeam".

I have made exports of the ones i can find in the SQL manegement studio and the containing data does not match the backupjobs.

In short, it seems like there is some database hidden somewhere outside of the management studio (or instance) that i am using.

The only alternative i can think of now is to make a complete clone of the veeamserver prior to upgrading it.
denit
Service Provider
Posts: 21
Liked: never
Joined: Oct 07, 2016 1:58 pm
Full Name: Denit Support
Location: the Netherlands
Contact:

Re: Way to find the right SQL database in Veeam?

Post by denit »

I may have found an answer, the registry.

Currently im looking into that, to find the active database used by Veeam.
denit
Service Provider
Posts: 21
Liked: never
Joined: Oct 07, 2016 1:58 pm
Full Name: Denit Support
Location: the Netherlands
Contact:

Re: Way to find the right SQL database in Veeam?

Post by denit »

I found the database in use, VeeamBR is the name.
However, this was one i exported an hour ago and the data does not match the jobnames and such.
It looks like old data.

Hmm, this is very confusing.

Edit : i tried different useraccounts as well, during the exports. Dedicated SQL accounts, local admin, useraccount. Nothing seems to give a satisfying result.

Maybe the database is messed up somehow.
Mike Resseler
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Way to find the right SQL database in Veeam?

Post by Mike Resseler »

Hi,

Indeed the registry is a good place to figure out where the database is. In my case it is standard: VeeamBackup and SQLinstancename = VeeamSQL2012. But there is also the VeeamBackupReporting database.

Is there a reason why you don't want to use the configuration backup and restore? (https://helpcenter.veeam.com/docs/backu ... tml?ver=95)

Thanks
Mike
denit
Service Provider
Posts: 21
Liked: never
Joined: Oct 07, 2016 1:58 pm
Full Name: Denit Support
Location: the Netherlands
Contact:

Re: Way to find the right SQL database in Veeam?

Post by denit »

Hi Mike,

Thanks for the reply.

That is a very good question indeed. I had seen that one before, but never really looked into it.
I was aiming for the complete backup of the SQL database.

But if that option you mention is also going to give me guarantee in case of failure, then i will do that.
Actually i see that it has already made 10 restorepoints on the default backup repository.

This is incredible stuff, i learn more and more of veeam everyday.

THanks again, your suggestion is much appreciated!
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Way to find the right SQL database in Veeam?

Post by foggy »

Yes, using this option is the right way to backup Veeam B&R configuration.
denit
Service Provider
Posts: 21
Liked: never
Joined: Oct 07, 2016 1:58 pm
Full Name: Denit Support
Location: the Netherlands
Contact:

Re: Way to find the right SQL database in Veeam?

Post by denit »

Thanks,

I also made sure it makes those configuration backups to another location, not on the "default backup repo".

Sincerely,

Stefan.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Way to find the right SQL database in Veeam?

Post by foggy »

This is also a good practice to ensure you always have configuration backup, even in case of a complete site loss.
Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 230 guests