Comprehensive data protection for all workloads
Post Reply
Mgamerz
Expert
Posts: 133
Liked: 23 times
Joined: Sep 29, 2017 8:07 pm
Contact:

What's stored in the Veeam SQL Database? Does it benefit from newer SQL version improvements?

Post by Mgamerz » Jul 15, 2019 4:43 pm

As far as I am aware, the SQL Server that is included in veeam (you can use your own, but that's not my question here) B&R is based on 2012 (or at least, it used to be. That's what mine was originally done as). I know some people in the past talked about upgrading the server to 2014 or 2016 or 2017 express and saw "speed improvements", but I was under the assumption that almost all data and metadata is not actually stored in the SQL Database, only really information about the backup environment (the configuration database).

Does upgrading the veeam SQL server to a new version - and setting the... can't recall the name off hand - the compatibility version to the same as the SQL server actually provide any real tangible benefit?

Dima P.
Product Manager
Posts: 10722
Liked: 881 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: What's stored in the Veeam SQL Database? Does it benefit from newer SQL version improvements?

Post by Dima P. » Jul 15, 2019 5:22 pm

Hello Mgamerz,

Express edition follows the same set of limitations described here. I'd rather recommend trying SQL Server Standard edition :wink:

Mgamerz
Expert
Posts: 133
Liked: 23 times
Joined: Sep 29, 2017 8:07 pm
Contact:

Re: What's stored in the Veeam SQL Database? Does it benefit from newer SQL version improvements?

Post by Mgamerz » Jul 15, 2019 6:35 pm

I understand the difference between same year editions of SQL Server, we don't have anything remotely large enough to use the full size of the DB. I am wondering about the query speed, and how much the DB is actually used in backup or restore operations. From what I can tell, the metadata for each restore point is stored in the restore point itself, and the guest index (if any) is stored in a separate zip file. With those components out of the way I don't know how much benefit one would get from upgrading SQL Server 2012 Express to 2017 Express, for example.

Here is an article (not from veeam) that talks about something like this: https://www.snurf.co.uk/veeam/veeam-upg ... -2016-sp1/

Gostev
SVP, Product Management
Posts: 25149
Liked: 3704 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: What's stored in the Veeam SQL Database? Does it benefit from newer SQL version improvements?

Post by Gostev » Jul 16, 2019 3:27 pm

The most significant improvement can be achieved by using SQL Server 2014 or later (for cardinality estimator). Overall though, we don't leverage the latest and greatest SQL Server features, because we need to be compatible with earlier SQL Server versions that we still support. Thanks!

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], vaglin and 23 guests