EV VAULT 9.0.X move sql DB's to new server
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
FCI.DisplayName AS 'Vault Store',
FCD.SQLServer AS 'SQL Server',
FCD.DatabaseName AS 'Database'
dbo.FingerprintCatalogueInstance AS FCI,
dbo.FingerprintCatalogueDatabase AS FCD
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.
SELECT @vaultStoreGroupName = N'ExpressVaultStoreGroup_1',
@fingerprintDBName = N'EVVSGExpressVaultStoreGroup_1_1',
@newSQLServerName = N'SYMVAULTDB'
Any help would be greatley appreciated!!!!!!!!!!!!!!