Way to find the right SQL database in Veeam?

Availability for the Always-On Enterprise

Way to find the right SQL database in Veeam?

Veeam Logoby denit » Wed Jan 11, 2017 8:16 am

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
Influencer
 
Posts: 18
Liked: never
Joined: Fri Oct 07, 2016 1:58 pm
Full Name: Denit Support

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

Veeam Logoby denit » Wed Jan 11, 2017 8:39 am

I may have found an answer, the registry.

Currently im looking into that, to find the active database used by Veeam.
denit
Influencer
 
Posts: 18
Liked: never
Joined: Fri Oct 07, 2016 1:58 pm
Full Name: Denit Support

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

Veeam Logoby denit » Wed Jan 11, 2017 8:42 am

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.
denit
Influencer
 
Posts: 18
Liked: never
Joined: Fri Oct 07, 2016 1:58 pm
Full Name: Denit Support

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

Veeam Logoby Mike Resseler » Wed Jan 11, 2017 9:08 am

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
Mike Resseler
Veeam Software
 
Posts: 3381
Liked: 384 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

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

Veeam Logoby denit » Wed Jan 11, 2017 10:34 am

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!
denit
Influencer
 
Posts: 18
Liked: never
Joined: Fri Oct 07, 2016 1:58 pm
Full Name: Denit Support

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

Veeam Logoby foggy » Wed Jan 11, 2017 11:02 am

Yes, using this option is the right way to backup Veeam B&R configuration.
foggy
Veeam Software
 
Posts: 15272
Liked: 1131 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

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

Veeam Logoby denit » Thu Jan 12, 2017 8:26 am

Thanks,

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

Sincerely,

Stefan.
denit
Influencer
 
Posts: 18
Liked: never
Joined: Fri Oct 07, 2016 1:58 pm
Full Name: Denit Support

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

Veeam Logoby foggy » Thu Jan 12, 2017 10:44 am

This is also a good practice to ensure you always have configuration backup, even in case of a complete site loss.
foggy
Veeam Software
 
Posts: 15272
Liked: 1131 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Google Feedfetcher, sg_sc and 7 guests