Comprehensive data protection for all workloads
Post Reply
sandsturm
Veteran
Posts: 279
Liked: 23 times
Joined: Mar 23, 2015 8:30 am
Contact:

Veeam backup for the VBR database

Post by sandsturm »

Hi all

I use a separate MSSQL server to host my Veeam database, it's not collocated on the same machine. Configuration backup is configured, so that the backup file is on a fileshare (not hosted on the veeam server). My question is now: Can I create a Veeam backup of the VBR database anyway? And can I change the recovery model of the VBR database from Simple to Full and create an application aware backup of this MSSQL server or do I'll encounter problems if I change the recovery model of this database?

thx,
sandsturm
foggy
Veeam Software
Posts: 21070
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam backup for the VBR database

Post by foggy »

You shouldn't encounter any problems, since Veeam B&R excludes its own database from VSS processing. Thanks!
sandsturm
Veteran
Posts: 279
Liked: 23 times
Joined: Mar 23, 2015 8:30 am
Contact:

Re: Veeam backup for the VBR database

Post by sandsturm »

I don't want to exclude the Veeam DB from processing. The thing is, that I want to create a backup of the Veeam database. Is that not possible?
heavy
Enthusiast
Posts: 25
Liked: 6 times
Joined: Sep 27, 2016 9:03 am
Full Name: Thomas Müller
Contact:

Re: Veeam backup for the VBR database

Post by heavy »

Why don't you just use the built-in Configuration Backup? That's essentially a database dump
wishr
Veteran
Posts: 3077
Liked: 453 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: Veeam backup for the VBR database

Post by wishr »

I would also recommend sticking with the configuration backup since this is the only officially supported method for performing backup and restore of the B&R server.
sandsturm
Veteran
Posts: 279
Liked: 23 times
Joined: Mar 23, 2015 8:30 am
Contact:

Re: Veeam backup for the VBR database

Post by sandsturm »

I use the configuration backup. But due to our internal process for MSSQL DB backups, the Veeam DB would be an exclusion within the process (organisational process) and therefore we need to configure special tasks around this DB, which would't be necessary if I just backup this DB with Veeam :-) Thats the reason for my question :-)
wishr
Veteran
Posts: 3077
Liked: 453 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: Veeam backup for the VBR database

Post by wishr »

It's not recommended to use Veeam Backup Jobs to backup B&R database. See here. Configuration backup is designed for this purpose.

Thanks
jmmarton
Veeam Software
Posts: 2092
Liked: 309 times
Joined: Nov 17, 2015 2:38 am
Full Name: Joe Marton
Location: Chicago, IL
Contact:

Re: Veeam backup for the VBR database

Post by jmmarton »

Maybe using a standalone Windows agent (not integrated into the VBR console) on the MSSQL server in question would allow for backup of the Veeam database if that's needed for internal IT policies?

Joe
sandsturm
Veteran
Posts: 279
Liked: 23 times
Joined: Mar 23, 2015 8:30 am
Contact:

Re: Veeam backup for the VBR database

Post by sandsturm »

that could be an option, thanks
Post Reply

Who is online

Users browsing this forum: hensowi, Mildur, Semrush [Bot] and 78 guests