Veeam database on sql 2014

Availability for the Always-On Enterprise

Veeam database on sql 2014

Veeam Logoby marieelieg » Thu 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!
marieelieg
Enthusiast
 
Posts: 64
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am

Re: Veeam database on sql 2014

Veeam Logoby foggy » Thu 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.
foggy
Veeam Software
 
Posts: 14742
Liked: 1080 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Veeam database on sql 2014

Veeam Logoby Shestakov » Thu Jul 27, 2017 4:02 pm

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!
Shestakov
Veeam Software
 
Posts: 4861
Liked: 396 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Veeam database on sql 2014

Veeam Logoby marieelieg » Fri 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
Enthusiast
 
Posts: 64
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am

Re: Veeam database on sql 2014

Veeam Logoby marieelieg » Fri 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-the-veeam-db-from-sql-express-to-production-sql-t39759.html#p221958
For Veeam ONE: https://www.veeam.com/kb1599 and https://www.veeam.com/kb1592

Thanks!
marieelieg
Enthusiast
 
Posts: 64
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am

Re: Veeam database on sql 2014

Veeam Logoby foggy » Fri Jul 28, 2017 2:11 pm

I'd ask support for advice, but the links look valid.
foggy
Veeam Software
 
Posts: 14742
Liked: 1080 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Veeam database on sql 2014

Veeam Logoby marieelieg » Fri Jul 28, 2017 3:48 pm

Okay thank you! :D
marieelieg
Enthusiast
 
Posts: 64
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Google [Bot] and 75 guests