VBR Configuration DB on ReFS volume

Availability for the Always-On Enterprise

VBR Configuration DB on ReFS volume

Veeam Logoby cip2013 » Fri Jan 20, 2017 8:33 pm

Has anyone seen issues with having VBR installed on an ReFS volume in regards to the configuration DB? I had read somewhere that ReFS doesn't play nice with SQL. I'm not sure if this is only an issue with older versions of ReFS or if this is something that still needs to be considered with Windows 2016. Should I be using ReFS for the repositories only? Also, could this have implications for Veeam Explorer for SQL when trying to do a restore? We are building some new backup servers and are trying to decide between ReFS and NTFS for the repository volumes.

I apologize if this has been answered elsewhere. I searched, but didn't find anything.
cip2013
Novice
 
Posts: 8
Liked: never
Joined: Wed May 06, 2015 9:36 pm
Full Name: Len Cipriani

Re: VBR Configuration DB on ReFS volume

Veeam Logoby PTide » Mon Jan 23, 2017 9:42 am

Hi,

It should not, at least DBCC CHECKDB issues has been resolved since SQL 2014.
Also, could this have implications for Veeam Explorer for SQL when trying to do a restore?

No. Just make sure that staging SQL server (if you use one) has the same or later version as the original SQL Server (the VM processed by Veeam job).

Thanks
PTide
Veeam Software
 
Posts: 3140
Liked: 262 times
Joined: Tue May 19, 2015 1:46 pm

Re: VBR Configuration DB on ReFS volume

Veeam Logoby v.Eremin » Mon Jan 23, 2017 10:32 am

And developing the thought regarding staging server, be aware to use one (full-blown SQL server) if you want to restore SQL db larger than 10 GB (maximum size SQL Express supports). Thanks.
v.Eremin
Veeam Software
 
Posts: 13558
Liked: 1006 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: VBR Configuration DB on ReFS volume

Veeam Logoby jmmarton » Mon Jan 23, 2017 2:16 pm

A question I have is what is the expected benefit of putting the VBR SQL DB on ReFS? There won't be anything we do to take advantage of ReFS for that. Unless there is a specific need, perhaps to install VBR on to the same server that will be used as a repository and move the database off the default C: drive (at least with SQL Express), I wouldn't mess with ReFS for the database. Just use it for the repository.

Joe
jmmarton
Veeam Software
 
Posts: 892
Liked: 95 times
Joined: Tue Nov 17, 2015 2:38 am
Location: Chicago, IL
Full Name: Joe Marton

Re: VBR Configuration DB on ReFS volume

Veeam Logoby cip2013 » Mon Jan 23, 2017 3:03 pm

I wouldn't mess with ReFS for the database. Just use it for the repository


Sounds good. I will install VBR on a non ReFS volume.

And developing the thought regarding staging server, be aware to use one (full-blown SQL server) if you want to restore SQL db larger than 10 GB (maximum size SQL Express supports).


I did not know this. This is a good thing to know. I don't think it will impact us as we do SQL backups and then just backup the files, but I will keep this in mind as we do have db's that are greater than 10GB.

Thanks for the info.
cip2013
Novice
 
Posts: 8
Liked: never
Joined: Wed May 06, 2015 9:36 pm
Full Name: Len Cipriani

Re: VBR Configuration DB on ReFS volume

Veeam Logoby v.Eremin » Mon Jan 23, 2017 5:09 pm

It's covered in more details in the corresponding section of our User Guide; might be useful for you. Thanks.
v.Eremin
Veeam Software
 
Posts: 13558
Liked: 1006 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to Veeam Backup & Replication



Who is online

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