Forum Discussion

Sani_B's avatar
Sani_B
Level 6
13 years ago

Help! How do I locate the fingerprint database in process of moving the Enterprise Vault (EV) SQL databases from one SQL server to another.

Hi,

I'm going to move the Enterprise Vault (EV) SQL databases from one SQL server to another following this article:

http://www.symantec.com/docs/TECH35744  (yes I have SQL specialist doing the heavy lifting)

 

There is a step for moving the fingerprint database and link to article http://www.symantec.com/docs/TECH64655 .

But neither of those tell me how to locate the fingerprint database... I have 9.0.2 version of EV so I know it's somewhere but I don't know where...??

Can anyone help? Information neede ASAP... Thank you!

 

Sani B.

Configuring
Enterprise Vault
Information Governance
Installing
Training
Upgrade
  • Wayne_Humphrey's avatar
    Wayne_Humphrey
    13 years ago

     

    You can use the following SQL query, to get a list of all Fingerprint Databases and there locations

    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

3 Replies

Sort By
  • Sani_B's avatar
    Sani_B
    Level 6
    13 years ago

    It's not something inside the EnterpriseVaultDirectory-database is it? And need only that script to read it properly?

    Or is it some folder somewhere on the EV server, which is where the EV database is now...?

     

    Sani B.

  • Wayne_Humphrey's avatar
    Wayne_Humphrey
    Level 6
    13 years ago

     

    You can use the following SQL query, to get a list of all Fingerprint Databases and there locations

    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