Comprehensive data protection for all workloads
Post Reply
marieelieg
Expert
Posts: 147
Liked: 8 times
Joined: Oct 20, 2016 7:15 am
Contact:

Veeam database on sql 2014

Post by marieelieg »

Hello everyone,

Just a question regarding the location of the Veeam Backup database.

If I have an SQL 2014 farm Always On, I cannot put the Backup DB on availability groups (as I saw in the VBR 9.5 user guide, under system requirements).

But as I understand, if I have an SQL 2014 Always On cluster, some of the DBs can exist as standalone and not on the availability group. In this case, can I host the backup DB as a standalone DB on SQL 2014 cluster?

And what about the Veeam ONE DB, can I put it on an availability group? If not, can I put it as a standalone DB on SQL 2014 cluster?

Thank you in advance :D
Hope you have a great day!
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam database on sql 2014

Post by foggy »

In user guide it actually states that Veeam B&R databases can be deployed on Microsoft SQL AlwaysOn Availability Groups. I believe it's the same for Veeam ONE.
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Veeam database on sql 2014

Post by Shestakov » 1 person likes this post

And what about the Veeam ONE DB, can I put it on an availability group? If not, can I put it as a standalone DB on SQL 2014 cluster?
Veeam ONE SQL AlwaysOn is oficially supported in v9.5, however customers reported that it works fine in earlier versions.
Thanks!
marieelieg
Expert
Posts: 147
Liked: 8 times
Joined: Oct 20, 2016 7:15 am
Contact:

Re: Veeam database on sql 2014

Post by marieelieg »

foggy wrote:In user guide it actually states that Veeam B&R databases can be deployed on Microsoft SQL AlwaysOn Availability Groups. I believe it's the same for Veeam ONE.
Ah OK, Thanks. I must have an older version of the user guide maybe.
marieelieg
Expert
Posts: 147
Liked: 8 times
Joined: Oct 20, 2016 7:15 am
Contact:

Re: Veeam database on sql 2014

Post by marieelieg »

In the user guide it said that "must modify a database connection registry key", can't I use DBConfig Utility instead? Or are the registry keys to be modified related to something else?

Also, now the Backup DB and Veeam ONE DB are on SQL 2012. If I want to migrate them to SQL 2014 Always On, should I use the following methods?
For VBR: veeam-backup-replication-f2/how-to-move ... ml#p221958
For Veeam ONE: https://www.veeam.com/kb1599 and https://www.veeam.com/kb1592

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

Re: Veeam database on sql 2014

Post by foggy »

I'd ask support for advice, but the links look valid.
marieelieg
Expert
Posts: 147
Liked: 8 times
Joined: Oct 20, 2016 7:15 am
Contact:

Re: Veeam database on sql 2014

Post by marieelieg »

Okay thank you! :D
Post Reply

Who is online

Users browsing this forum: BartP, Gostev, Kristina.Zalesakova, kyle.shuberg, Semrush [Bot] and 181 guests