Discussions specific to the VMware vSphere hypervisor
Post Reply
jbrullemans
Enthusiast
Posts: 41
Liked: 1 time
Joined: Mar 09, 2011 8:22 am
Full Name: John Brullemans
Contact:

SQL Version on Backup server

Post by jbrullemans » 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?

veremin
Product Manager
Posts: 16901
Liked: 1438 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Version on Backup server

Post by veremin » Dec 03, 2014 9:23 am

Hi, John, please refer to MS documentation for information regarding SQL upgrade procedure. Thanks.

jbrullemans
Enthusiast
Posts: 41
Liked: 1 time
Joined: Mar 09, 2011 8:22 am
Full Name: John Brullemans
Contact:

Re: SQL Version on Backup server

Post by jbrullemans » 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?

veremin
Product Manager
Posts: 16901
Liked: 1438 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Version on Backup server

Post by veremin » Dec 03, 2014 2:53 pm

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

kloby
Novice
Posts: 3
Liked: never
Joined: Mar 04, 2015 7:20 am
Contact:

Re: SQL Version on Backup server

Post by kloby » 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 ?

foggy
Veeam Software
Posts: 18278
Liked: 1564 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Version on Backup server

Post by foggy » 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.

doomi
Veeam ProPartner
Posts: 38
Liked: 2 times
Joined: Aug 11, 2015 3:31 pm
Full Name: Dominic Wyss
Contact:

Re: SQL Version on Backup server

Post by doomi » 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?

P.Tide
Product Manager
Posts: 5264
Liked: 459 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: SQL Version on Backup server

Post by P.Tide » 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.

btmaus
Expert
Posts: 138
Liked: 10 times
Joined: Jul 17, 2015 9:02 am
Full Name: Glenn L
Contact:

Re: SQL Version on Backup server

Post by btmaus » 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?

veremin
Product Manager
Posts: 16901
Liked: 1438 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Version on Backup server

Post by veremin » 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.

Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests