topic Re: 3 old separate vaults in Vault Forum

3 old separate vaults

andrew_canfield — Mon, 14 Sep 2020 13:20:03 GMT

Hello

There are 3 old separate vaults - the data is from old projects - it may or may not be needed in the future.

Being separate Vaults means restoring then to 3 VM's - 3 operating systems, 3 sql licenses - for data which may not be access (or accessed infrequently).

I know this idea is a bit crazy but I'm after a sanity check.

Get latest on all Vaults.

Copy the Vault Working folder data to one machine(keeping the folder structure).

Make the folder read only.

Obviously the search function would be lost.

Using autoloader to add 300 GB to a new 2020 vault may take months to clean up data from 3 combined vaults.

The saving would be 2 off VM's o/s & sql

Regards

Andrew

Re: 3 old separate vaults

CGBenner — Mon, 14 Sep 2020 19:09:55 GMT

@andrew_canfield

Hi,... I'm sorry if I'm not reading your post right. Were you looking for someone to validate your workflow before you try it? Or was this what you have already done?

Re: 3 old separate vaults

andrew_canfield — Mon, 14 Sep 2020 19:52:41 GMT

Hello Chris

I've been away from Vault for a while (2014?) & currently thinking about how 3 vaults can be combined.

The change is being forced by old projects in Windows 7 & Server 2008 going end of life.

I've seen a later post:

https://knowledge.autodesk.com/support/vault-products/learn-explore/caas/sfdcarticles/sfdcarticles/How-to-merge-vaults-from-multiple-servers.html

& currently reading up.

I've a week to figure out how to archive data which may or may not be needed.

Thanks for the reply

Regards

Andrew

Re: 3 old separate vaults

CGBenner — Thu, 17 Sep 2020 18:06:39 GMT

@andrew_canfield

Have you had any luck with this or do I need to call in the big guns?

Re: 3 old separate vaults

andrew_canfield — Fri, 18 Sep 2020 07:49:50 GMT

Hello Chris

Currently there are 3 old vaults on 3 adms servers.

They are currently being migrated.

I think I can set up a new adms to hold 3 vaults

Restore a backup from 1 of the old vaults then just copy the other 2 onto the new vault.

(which will lose version history - but that's fine. Everything will be purged anyway).

Hopefully will have this sorted before month end.

Regards

Andrew

Re: 3 old separate vaults

CGBenner — Fri, 18 Sep 2020 11:30:44 GMT

@andrew_canfield

Ok, thanks for the update. I just wanted to make sure you weren't stuck and waiting for advice. Please let us know how this all turns out, and good luck!

Re: 3 old separate vaults

andrew_canfield — Fri, 25 Sep 2020 10:38:25 GMT

Hello Chris

Server M is running:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)

Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)

Server L is running:

Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64)
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

Server L is going to be updated & the Server M backup is the largest. I think less files would need moving if the Server M backup can be restored to Server L (which is going to be updated)

Can an 'Standard Edition sql Vault Backup' be restored to a 'Enterprise Edition sql Vault server'?

Regards

Andrew

Re: 3 old separate vaults

CGBenner — Fri, 25 Sep 2020 12:11:02 GMT

@andrew_canfield

@andrew_canfield wrote:

Can an 'Standard Edition sql Vault Backup' be restored to a 'Enterprise Edition sql Vault server'?

I would think that the backup file format should be the same for both, but let me tag in @ihayesjr to verify before you start with the restore process.

Re: 3 old separate vaults

ihayesjr — Fri, 25 Sep 2020 14:42:01 GMT

Looking through the thread I am not exactly sure what state you are at.

Your original post seems to be the best approach to me. Backing up and restoring to other servers seems to be too much for what you are going to do in the end.

Do a get on the existing server installation and use Autoloader to load them into the final server.

Saves you a lot of unnecessary work of backing up and restoring to another server.

To answer your last question, yes you can restore databases from a Standard version of SQL to the Enterprise version of SQL. But based on what you are trying to get to, this seems to be unnecessary work as I previously stated.