SQL Version on Backup server

VMware specific discussions

SQL Version on Backup server

Veeam Logoby jbrullemans » Wed Dec 03, 2014 7:11 am

Hi,

When i run a backup for a VM i receive this message:

SQL Server version used by the backup server is older than the one installed in this VM. Upgrade is recommended to avoid issues with application items restore.

How can i upgrade the SQL version of the Veeam Server?
jbrullemans
Enthusiast
 
Posts: 38
Liked: 1 time
Joined: Wed Mar 09, 2011 8:22 am
Full Name: John Brullemans

Re: SQL Version on Backup server

Veeam Logoby v.Eremin » Wed Dec 03, 2014 9:23 am

Hi, John, please refer to MS documentation for information regarding SQL upgrade procedure. Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SQL Version on Backup server

Veeam Logoby jbrullemans » Wed Dec 03, 2014 2:49 pm

Hi,

I know but it says that i need to update the SQL version of Veeam. What is the easiest way of doing that? download SQLExpress 2012 and upgrade the database or are there special database things needed for veeam?
jbrullemans
Enthusiast
 
Posts: 38
Liked: 1 time
Joined: Wed Mar 09, 2011 8:22 am
Full Name: John Brullemans

Re: SQL Version on Backup server

Veeam Logoby v.Eremin » Wed Dec 03, 2014 2:53 pm

Just update underlying SQL server, there are no Veeam-specific requirements. Be aware to backup configuration first. Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SQL Version on Backup server

Veeam Logoby kloby » Wed Mar 25, 2015 11:45 am

So if its SQL server 2012 installed on Veem server and on backup-ed VM is SQL 2014 I should install SQL 2014 on Veem server ?
kloby
Novice
 
Posts: 3
Liked: never
Joined: Wed Mar 04, 2015 7:20 am

Re: SQL Version on Backup server

Veeam Logoby foggy » Wed Mar 25, 2015 2:48 pm

If you're going to use Veeam Explorer for SQL Server for application items restore, you would need to have a staging SQL Server, which has the same or later version as the original backed up SQL Server. By default, local SQL Server deployed with Veeam backup server is used, so you can either upgrade it or specify another compatible SQL server for application items restores.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Version on Backup server

Veeam Logoby doomi » Mon Sep 14, 2015 8:03 am

foggy wrote:or specify another compatible SQL server for application items restores.

how / where can I specify another sql server?
haven't seen a setting for that in the restore procedure.
is there a setting in the SQL explorer for that?
doomi
Veeam ProPartner
 
Posts: 38
Liked: 2 times
Joined: Tue Aug 11, 2015 3:31 pm
Full Name: Dominic Wyss

Re: SQL Version on Backup server

Veeam Logoby PTide » Mon Sep 14, 2015 10:00 am

Hi,

is there a setting in the SQL explorer for that?
You need to open a drop-down list (icon in a top-left corner) in Veeam Explorer and chose "Options" - there you can specify another SQL serer for staging.

Thank you.
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm

Re: SQL Version on Backup server

Veeam Logoby btmaus » Mon Sep 28, 2015 6:08 am

v.Eremin wrote:Just update underlying SQL server, there are no Veeam-specific requirements. Be aware to backup configuration first. Thanks.


I'm getting this message as well. So is it fine to leave the Veeam SQL server as it is (SQL 2012), to do the backups, but when it comes time to do a restore, I can specify a "newer" SQL staging server to use?
btmaus
Expert
 
Posts: 128
Liked: 9 times
Joined: Fri Jul 17, 2015 9:02 am
Full Name: Glenn L

Re: SQL Version on Backup server

Veeam Logoby v.Eremin » Mon Sep 28, 2015 11:22 am

The staging server should be local (place where VB&R and VESQL are installed), since we're still working on adding support for remote staging server for VESQL. Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 17 guests