EV VAULT 9.0.X move sql DB's to new server

[SammyC3]

I had my symvault server die with no known good backups. I had to restore from a 6 week old backup. I was able to get the majority of everything backup and the Vault concil working but I am having a brain fart on updating the Fingerprint database to reflect the change to the new sql server.

I found TECH64655 great for the sql command but detemining the varaiables has been a bit of a task. The script has a note to modify

SELECT @vaultStoreGroupName = N'VSG_NAME', -- The name of the Vault Store Group to be moved. This can be found under "Display Name" in the VaultStoreGroup table.
@fingerprintDBName = N'FPCDB_NAME', -- The name of the database that has been moved to a different SQL server
@newSQLServerName = N'NEW_SQL_SERVER_NAME' -- The name of the new SQL Server

Have the new Sql Name no problem! LOL 11 days of Chaoss to get to here!

VaultstoreGroup and Fingerprint dbname are my problems

I found

USE EnterpriseVaultDirectory
 
SELECT
 
FCI.DisplayName AS 'Vault Store',
 
FCD.SQLServer AS 'SQL Server',
 
FCD.DatabaseName AS 'Database'
 
FROM
 
dbo.FingerprintCatalogueInstance AS FCI,
 
dbo.FingerprintCatalogueDatabase AS FCD
 
WHERE
 
FCI.FPCIIdentity=FCD.FPCIIdentity

Results are

VaultStore                                        SqlServer                     Databasename

ExpressVaultStoreGroup_1            Symvault                       EVVSGExpressVaultStoreGroup_1_1         In SQL Server Coloumn this the old server

I plug in to the above refrenced script the variables below.

Snipped

SELECT @vaultStoreGroupName = N'ExpressVaultStoreGroup_1', 
@fingerprintDBName = N'EVVSGExpressVaultStoreGroup_1_1',
@newSQLServerName = N'SYMVAULTDB'

Any help would be greatley appreciated!!!!!!!!!!!!!!

[JesusWept3]

OK i'm really confused because it looks like you have what you need?

[SammyC3]

Thats what I thought but I receive the below statement in the sql message window when I run the update script.

Could not find the corresponding record to update SQL server name for the input fingerprint database.

This problem came up when I log onto the Vault Admin Console on the original server. Once I open the console I go to Express Vault Store Group on the council. Go to properties and the sql server is set to the old sql server/VAC and it reflects symvault instead of symvaultdb.

If I use this script to find the Fingerprint Database and store it shows the old server.

USE EnterpriseVaultDirectory

SELECT

FCI.DisplayName AS 'Vault Store',

FCD.SQLServer AS 'SQL Server',

FCD.DatabaseName AS 'Database'

FROM

dbo.FingerprintCatalogueInstance AS FCI,

dbo.FingerprintCatalogueDatabase AS FCD

WHERE

FCI.FPCIIdentity=FCD.FPCIIdentity

[Jeff_Shotton]

You get that message if the rowcount is zero...but im sure you know that.

What do you get if you run this? (basically the select version of the update script,without a filter)

USE EnterpriseVaultDirectory

SELECT * FROM dbo.FingerprintCatalogueDatabase fpcdb
INNER JOIN dbo.FingerprintCatalogueInstance fpci
ON fpcdb.FPCIIdentity = fpci.FPCIIdentity
INNER JOIN dbo.VaultStoreGroup vsg
ON fpci.VaultStoreGroupIdentity = vsg.VaultStoreGroupIdentity

Regards,

Jeff

[Jeff_Shotton · Accepted solution]

Then try this to get the parameters....

SELECT '''' + vsg.DisplayName + '''','''' + fpcdb.Databasename + '''' FROM dbo.FingerprintCatalogueDatabase fpcdb
INNER JOIN dbo.FingerprintCatalogueInstance fpci
ON fpcdb.FPCIIdentity = fpci.FPCIIdentity
INNER JOIN dbo.VaultStoreGroup vsg
ON fpci.VaultStoreGroupIdentity = vsg.VaultStoreGroupIdentity

.it will add the quotes in for you just in case a space or some other character has snuck in there at the end of the string (although I've no idea why that would happen)