Quick question: SQL Express 2016 for VBR server?

Availability for the Always-On Enterprise

Quick question: SQL Express 2016 for VBR server?

Veeam Logoby john.brodhurst » Wed May 10, 2017 4:32 pm

I'm planning new install, and I want everything shiny and new. Is SQL Server Express Edition 2016 supported on the 9.5 U1 Veeam server to back the VBR database? I know the in-box SQL install is 2012 (or at least it was last time I installed VBR 9). Sorry if I've missed something, but I've spent some time today searching and I couldn't find a definitive answer.
john.brodhurst
Influencer
 
Posts: 18
Liked: 1 time
Joined: Fri May 11, 2012 12:16 pm
Location: Canterbury, UK
Full Name: John Brodhurst

Re: Quick question: SQL Express 2016 for VBR server?

Veeam Logoby foggy » Wed May 10, 2017 4:36 pm

Hi John, it's right in the system requirements section. Yes, you can use SQL Server Express Edition 2016 with Veeam B& 9.5 U1.
foggy
Veeam Software
 
Posts: 14560
Liked: 1060 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Quick question: SQL Express 2016 for VBR server?

Veeam Logoby jmmarton » Wed May 10, 2017 6:00 pm

It's also recommended to upgrade the included SQL Express 2012 to at least 2014.

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

Re: Quick question: SQL Express 2016 for VBR server?

Veeam Logoby john.brodhurst » Fri May 12, 2017 9:56 am

Thanks for the replies. I did not find that system requirements section in my searching but logically that is the first place I should have looked, sorry.

On a related note, is it too much to hope that Veeam 8.0 U3 supports 2016? I have another upgrade project which is a bigger leap. If necessary, I could do the SQL upgrade after the Veeam upgrade potentially, as its currently using 2012 which I think is the in-box version so this should install without complaints.
john.brodhurst
Influencer
 
Posts: 18
Liked: 1 time
Joined: Fri May 11, 2012 12:16 pm
Location: Canterbury, UK
Full Name: John Brodhurst

Re: Quick question: SQL Express 2016 for VBR server?

Veeam Logoby foggy » Fri May 12, 2017 12:51 pm

SQL Server 2016 support was introduced in version 9.5, so you'd better upgrade Veeam B&R first.
foggy
Veeam Software
 
Posts: 14560
Liked: 1060 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Quick question: SQL Express 2016 for VBR server?

Veeam Logoby john.brodhurst » Fri May 12, 2017 12:54 pm

Got it - thanks for the quick reply.
john.brodhurst
Influencer
 
Posts: 18
Liked: 1 time
Joined: Fri May 11, 2012 12:16 pm
Location: Canterbury, UK
Full Name: John Brodhurst

Re: Quick question: SQL Express 2016 for VBR server?

Veeam Logoby jazzoberoi » Sun May 14, 2017 1:00 am

Hi, Can we upgrade the SQL 2012 express that gets installed with Veeam directly to 2016 SP1 ?

Also, which version of the SQL Express 2016 do we need to download, as there are 3 options:

- SQL Server 2016 SP1 Express
- SQL Server 2016 Express with Advanced Services
- SQL Server 2016 Express LocalDB

Thanks.
jazzoberoi
Enthusiast
 
Posts: 63
Liked: 13 times
Joined: Wed Oct 08, 2014 9:07 am
Full Name: Jazz Oberoi

Re: Quick question: SQL Express 2016 for VBR server?

Veeam Logoby unsichtbarre » Sun May 14, 2017 4:19 pm

SQL Server 2016 Express with Advanced Services has the management tools you will need to create/browse the database.
unsichtbarre
Enthusiast
 
Posts: 59
Liked: 14 times
Joined: Mon Mar 08, 2010 4:05 pm
Full Name: John Borhek

Re: Quick question: SQL Express 2016 for VBR server?

Veeam Logoby john.brodhurst » Mon May 15, 2017 7:36 am

jazzoberoi wrote:Hi, Can we upgrade the SQL 2012 express that gets installed with Veeam directly to 2016 SP1 ?


You most definitely can do an in-place upgrade as long as you choose the instance when running the setup wizard - the full details are here: Upgrade SQL Server Using the Installation Wizard (relevant to all SKUs of SQL Server including Express)
john.brodhurst
Influencer
 
Posts: 18
Liked: 1 time
Joined: Fri May 11, 2012 12:16 pm
Location: Canterbury, UK
Full Name: John Brodhurst


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot] and 20 guests