topic Re: Vault Backup Error message in Vault Forum

Vault Backup Error message

Anonymous — Wed, 28 Oct 2015 13:16:45 GMT

Hello

Im presenting this issue

Issue:

When you try to restore a Vault backup, the following error message is displayed:

Restore failed because the backup has products that are not supported by the server

Causes:

This error can occur for the following reasons:

Product update was applied to the backup server, but hasn’t been applied to the restoring server.
Backup was created in higher version of Vault than the restoring server. (For example, the backup was created in Vault Professional, and you are restoring in Vault "basic.")
Backup was created in a newer release than the restoring server. (For example, the backup was created in Vault 2014, and you are restoring in Vault 2013.)

Solution:

Try the following solutions:

Ensure the update, service pack, or hotfix of the backup server matches the restoring server.
Ensure the Vault version and product match.
Ensure the Vault releases match.

Can you give me more information about the solution part

1 do you mean the SQL Version that im running???

2 how can I compare the version that I have, I open the backupcontent.XML file and I have this

- <Products>
<Product Name="Autodesk.Productstream" Version="17.2.9.0" />
<Product Name="Autodesk.Vault" Version="17.2.9.0" />
<Product Name="Autodesk.VaultCollaboration" Version="17.2.9.0" />
<Product Name="Autodesk.VaultPro" Version="17.2.9.0" />
</Products>

Where can I compare this or how should I know what is the version of vault that im running?? The vault I have is the Vault 2013 (ADMS)

3 how can I see the release that I have

Here is the thing im working on a project of upgrade to version 2015 of vault, but we want to do the backup into a VM, right now I have a backup with the content that I provide above, and this backup was made by another person which I no longer have communication, and since of that I do not know where he did this back up under what version of vault with what SQL version I do not know nothing about this, and I did a restore on vault 2015 but I have an error message saying that my backup is not compatible, so right now I downgrade to version 2013 and SQL R1 SP1 to do a restore and then upgrade to SQL R2 to do a backup again and then restore it into a vault 2015 version but I have this error when I try to do the restore, can you help me out to see what I need to update if is my sql or if I need to update downgrade vault, please help

Regards!

José Antonio Mendoza | Autodesk & Vault Tools Support
Softtek | Blvd. Díaz Ordaz KM 333 | Plaza La Leona Secc IV | San Pedro Garza García, NL 66210

Tel: +52 (81) 8153 2000 ext. 2054 | www.softtek.com

twitter.com/Softtek | linkedin.com/company/Softtek | facebook.com/Softtek | feeds.feedburner.com/SofttekBlog | youtube.com/SofttekTV

Re: Vault Backup Error message

Neil_Cross — Wed, 28 Oct 2015 13:30:41 GMT

Hi José,

The backup version is from Vault 2013 Update 1 for Service Pack 1. However I can't tell which product level that is, i.e. standard Vault or Professional etc.

Download and install this: http://knowledge.autodesk.com/support/vault-products/downloads/caas/downloads/content/vault-2013-service-pack-1.html?v=2013

Then this: http://knowledge.autodesk.com/support/vault-products/downloads/caas/downloads/content/update-1-for-vault-2013-service-pack-1.html?v=2013

So are you saying that you have no access to the Vault or server that this backup was taken from?

Re: Vault Backup Error message

Anonymous — Wed, 28 Oct 2015 13:44:32 GMT

Thats right i do not know in what versi?n of vault was did, im running ad vault 2013
[cid:image001.png@01D11154.6B5A9A80]

Jos? Antonio Mendoza | Autodesk & Vault Tools Support
Softtek | Blvd. D?az Ordaz KM 333 | Plaza La Leona Secc IV | San Pedro Garza Garc?a, NL 66210
Tel: +52 (81) 8153 2000 ext. 2054 | www.softtek.com
twitter.com/Softtek | linkedin.com/company/Softtek | facebook.com/Softtek | feeds.feedburner.com/SofttekBlog | youtube.com/SofttekTV

Re: Vault Backup Error message

Anonymous — Wed, 28 Oct 2015 13:52:20 GMT

sorry the image didnt show

the product is Vault Professional Server 17.0.62.0

Build 17.0.62.0

Re: Vault Backup Error message

Neil_Cross — Wed, 28 Oct 2015 13:54:12 GMT

That is very unusual. How can a vault server just disappear? Or has it been taken offline and wiped? How can you be sure people aren't still working on the original Vault and that you have an old backup?

It could also be that the original Vault may be from Vault Professional and you're trying to restore into Vault Basic

Re: Vault Backup Error message

Neil_Cross — Wed, 28 Oct 2015 13:56:28 GMT

Oh ok, then if you have Vault Pro Server, install service pack 1 then update 1 for 2013 and you should be half way there.

Are you restoring into SQL Express?

Re: Vault Backup Error message

Anonymous — Wed, 28 Oct 2015 14:06:58 GMT

Oh because this person is no loger working over here, he was using a VM but was deleted because we need disk space to create another one for me

Jos? Antonio Mendoza | Autodesk & Vault Tools Support
Softtek | Blvd. D?az Ordaz KM 333 | Plaza La Leona Secc IV | San Pedro Garza Garc?a, NL 66210
Tel: +52 (81) 8153 2000 ext. 2054 | www.softtek.com
twitter.com/Softtek | linkedin.com/company/Softtek | facebook.com/Softtek | feeds.feedburner.com/SofttekBlog | youtube.com/SofttekTV

Re: Vault Backup Error message

Anonymous — Wed, 28 Oct 2015 15:31:18 GMT

done im doing the restore again, hope i get lucky this time, the main thing is that im trying to restore this backup over a vault version 2015 but it saids that is not compatible so what im trying to do is restore it over 2013 and then i dont know migrate or update just the vault 2013 to 2015 or again do a backup to be compatible with the vault 2015 or update SQL Server 2008 R1 to R2, any suggestion?

Re: Vault Backup Error message

Anonymous — Wed, 28 Oct 2015 18:45:56 GMT

SQL Server 2008 R1

Re: Vault Backup Error message

Neil_Cross — Wed, 28 Oct 2015 19:01:10 GMT

Make sure you have SP3 on that instance too.

http://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2015-products.html

Re: Vault Backup Error message

Anonymous — Wed, 28 Oct 2015 21:44:13 GMT

ok i dont get it im back to the same error i was having when i try the first time, i see the log file and i get this

The database or backup is not compatible with the database server. This error may be caused by restoring or attaching files from a version of SQL Server that is higher than the version of your SQL Server.
10/28/2015 5:09:50 PM Connectivity.Application.VaultManager.ServiceException: DatabaseServerNotCompatible [198] ---> Connectivity.Core.Exceptions.CoreException: DatabaseServerNotCompatible [198] ---> System.Data.SqlClient.SqlException: The database was backed up on a server running version 10.50.4000. That version is incompatible with this server, which is running version 10.00.4000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

is this what your saying to update the sql server 2008 R1 to SP3?? and thats how im gonna change the version to 10.50.4000??

Re: Vault Backup Error message

Neil_Cross — Wed, 28 Oct 2015 21:56:00 GMT

Whoaaa you never said your log had provided SQL version numbers!

10.50.4000 is SQL 2008 R2 (SP2)

You are using SQL 2008 (SP2)

You need to get yourself the R2 version. Put service pack 2 on. Then you're all good.

Until now I thought you had no way of determining which version of SQL this had come from so we were guessing, that's a definite answer there.

Re: Vault Backup Error message

Anonymous — Wed, 28 Oct 2015 22:02:41 GMT

sorry for that im new on this, so before i update, the backup that i have, i want to restore it on a new computer for example, if i install the vault server 2015 with that sql server the R2 SP2 am i ok to do it ? or else i need first to create the backup over this version (Vault 2013 SQL with SQL R2 SP2) and then do another backup so i can get it restore on the Vault 2015?? makes sense?

because the main task that i need or want it to do is to have this backup runing with the Vault Server 2015 for doing some test since that we are going to upgrade to that version.

Re: Vault Backup Error message

Neil_Cross — Wed, 28 Oct 2015 22:15:58 GMT

Well we've established now that your backup is from Vault 2013 SP1 Update 1, and the SQL version was 2008 R2 SP2.

As you don't have the existing/old Vault server (it went missing or was deleted) there is no point in you thinking about installing Vault 2013.

So if I was you, do this:

On your new VM, install SQL 2008 R2 SP2.

Then install Vault Professional Server 2015, put ALL the latest service packs and hotfixes on. I think it's up to SP2 now.

Restore your backup into that.

Providing there are no other issues which you don't know of, it should all go smoothly. Obviously you'll need a license for Vault Professional 2015 as it doesn't have a trial period.

Re: Vault Backup Error message

Anonymous — Wed, 28 Oct 2015 22:40:03 GMT

ok lets do this, and yes i already have the license the only thing is the updates for vault 2015 im on it, thanks a lot Neil ill keep you inform if it works

Re: Vault Backup Error message

Anonymous — Thu, 29 Oct 2015 22:31:43 GMT

bad news

now i got this:

10/29/2015 2:11:19 PM ==================================================================
10/29/2015 2:11:19 PM RESTORE PROGRESS: The server console is currently in the process of restoring a backup set. Please wait...
10/29/2015 2:11:19 PM ==================================================================
10/29/2015 6:20:27 PM The database or backup is not compatible with the database server. This error may be caused by restoring or attaching files from a version of SQL Server that is higher than the version of your SQL Server.
10/29/2015 6:20:28 PM Connectivity.Application.VaultManager.ServiceException: DatabaseServerNotCompatible [198] ---> Connectivity.Core.Exceptions.CoreException: DatabaseServerNotCompatible [198] ---> System.Data.SqlClient.SqlException: The database was backed up on a server running version 10.50.4000. That version is incompatible with this server, which is running version 10.00.5500. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

any idea?? do i upgrade the SQL to SP3 ??

Re: Vault Backup Error message

Neil_Cross — Thu, 29 Oct 2015 22:50:26 GMT

You've still got the wrong version of SQL installed.

You have SQL 2008 SP3.

You need to have SQL 2008 R2 SP2 or higher.

The two versions although both named 2008, are different versions.

Re: Vault Backup Error message

Anonymous — Thu, 29 Oct 2015 23:05:08 GMT

how can i see the version that i have of sql besides the log file ??

Re: Vault Backup Error message

Neil_Cross — Thu, 29 Oct 2015 23:16:08 GMT

There's a few ways, this one will probably do:

https://support.cch.com/kb/solution.aspx/sw1873

Re: Vault Backup Error message

Anonymous — Thu, 29 Oct 2015 23:33:34 GMT

now im crazy! lol