Comprehensive data protection for all workloads
Post Reply
sandsturm
Enthusiast
Posts: 99
Liked: 10 times
Joined: Mar 23, 2015 8:30 am
Contact:

Sharepoint restore fails due to database incompatibilities

Post by sandsturm » Feb 11, 2019 9:27 am

Hi

I tried to setup the sharepoint backup within Veeam backup today. My environment is the following: Sharepoint database is on MSSQL 2012 Enterprise, Veeam staging server is on MSSQL 2016 Enterprise. If I want to start the Sharepoint Veeam Explorer and try to mount the database, I get the message:
The selected SharePoint database has to be upgraded to be open in the specified Microsoft SQL Server 2016. After database upgrade, older versions of SQL server will not be able to open this database. Do you want to continue?
After clicking "No", the message:
The selected Microsoft SharePoint database version is older than any of the supported by the specified Microsoft SQL Server 2016. Upgrade was denied.
In my opinion, it's just important to have the staging server on the highest version to be able to mount databases from older SQL servers, or am I wrong?

thx,
sandsturm

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

Re: Sharepoint restore fails due to database incompatibilities

Post by foggy » Feb 11, 2019 5:13 pm 1 person likes this post

SQL Server upgrades the database automatically, otherwise it cannot be mounted.

sandsturm
Enthusiast
Posts: 99
Liked: 10 times
Joined: Mar 23, 2015 8:30 am
Contact:

Re: Sharepoint restore fails due to database incompatibilities

Post by sandsturm » Feb 12, 2019 8:38 am

which database will be upgraded in this case? The sharepoint database?

nielsengelen
Veeam Software
Posts: 2389
Liked: 510 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Sharepoint restore fails due to database incompatibilities

Post by nielsengelen » Feb 12, 2019 11:34 am

This will upgrade the SharePoint database to make sure it can be restored there. This is due to difference between 2012 and 2016.
VCP-DCV
Veeam Certified Architect (VMCA)
http://foonet.be

sandsturm
Enthusiast
Posts: 99
Liked: 10 times
Joined: Mar 23, 2015 8:30 am
Contact:

Re: Sharepoint restore fails due to database incompatibilities

Post by sandsturm » Feb 13, 2019 6:10 am

But I cannot upgrade all my databases to mssql 2016, just because I want to backup them? For some of our applications I wouldn't have a supported configuration if I just update the database, some software venors do have a list of supported databases and if such a database is not compatible with mssql 2016, I can't upgrade them. Is that really the way to go for all MSSQL backups or is this just a requirement for the Sharepoint backup? I can't believe that?

thx,
sandsturm

Mike Resseler
Product Manager
Posts: 5457
Liked: 574 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Sharepoint restore fails due to database incompatibilities

Post by Mike Resseler » Feb 13, 2019 6:37 am

Hi Sandsturm,
In case of the Veeam explorer, besides mounting the database and mount it to a staging server, we need SQL server itself do specific items to give you the view of all of those Sharepoint sites and lists and documents and such... Otherwise your view in the explorer would be very empty :-).

Now. Just to be clear:
If you want to restore an entire SharePoint site, including VM. That won't be a problem at all.
If you want to do ILR with your current staging server, then it is also not a problem. It will ask you to "upgrade" the database but nothing will happen. We mount it in "read-only". Your backup will NOT be altered. Then you can browse, look at whatever you need to restore, and do that ILR of the specific database to the SharePoint site (with the 2012 database). After you are done, and stop the Veeam explorer, the so-called changes to that database inside the backup are simply thrown away.

Makes sense?

Thanks
Mike

Post Reply

Who is online

Users browsing this forum: Google [Bot], Karinne and 16 guests