Vault Backup Error message

[Anonymous]

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:

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

Can you give me more information about the solution part

On

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

[Neil_Cross]

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-ser...

Then this: http://knowledge.autodesk.com/support/vault-products/downloads/caas/downloads/content/update-1-for-v...

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

[Anonymous]

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

[Anonymous]

sorry the image didnt show

the product is Vault Professional Server 17.0.62.0

Build 17.0.62.0

[Neil_Cross]

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

[Neil_Cross]

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?

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

SQL Server 2008 R1

[Neil_Cross · Accepted solution]

Make sure you have SP3 on that instance too.

http://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/...

[Anonymous]

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??

[Neil_Cross]

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.

[Anonymous]

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.

[Neil_Cross]

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.

[Anonymous]

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

[Anonymous]

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 ??

[Neil_Cross]

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.

[Anonymous]

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

[Neil_Cross]

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

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

[Anonymous]

now im crazy! lol