Availability for the Always-On Enterprise
Post Reply
marieelieg
Expert
Posts: 101
Liked: 4 times
Joined: Oct 20, 2016 7:15 am
Contact:

Veeam database on sql 2014

Post by marieelieg » Jul 27, 2017 7:35 am

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: 16691
Liked: 1343 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam database on sql 2014

Post by foggy » Jul 27, 2017 2:02 pm

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
Veeam Software
Posts: 5924
Liked: 514 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Veeam database on sql 2014

Post by Shestakov » Jul 27, 2017 4:02 pm 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: 101
Liked: 4 times
Joined: Oct 20, 2016 7:15 am
Contact:

Re: Veeam database on sql 2014

Post by marieelieg » Jul 28, 2017 4:55 am

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: 101
Liked: 4 times
Joined: Oct 20, 2016 7:15 am
Contact:

Re: Veeam database on sql 2014

Post by marieelieg » Jul 28, 2017 5:11 am

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: 16691
Liked: 1343 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam database on sql 2014

Post by foggy » Jul 28, 2017 2:11 pm

I'd ask support for advice, but the links look valid.

marieelieg
Expert
Posts: 101
Liked: 4 times
Joined: Oct 20, 2016 7:15 am
Contact:

Re: Veeam database on sql 2014

Post by marieelieg » Jul 28, 2017 3:48 pm

Okay thank you! :D

Post Reply

Who is online

Users browsing this forum: No registered users and 27 guests