Forum Discussion

Todd_Anderson's avatar
Todd_Anderson
Level 4
16 years ago

EV8 Database problem

We have a small enviroment and we have one server that is running SQL 2005 and EV8.0 together. We have a small c partion for the program files and a large D partion for all the data. When setting up the SQL server and the EV setup we created databases on the D partiton and pointed the vault stores to this place. Today I have noticed that we are running out of space on the C partiton and we found that there is a database under the SQL program files folder. Does anyone know what this database is for and can it be moved to the D partition? I hope this makes sense...

Thanks.

Todd Anderson
Database
Enterprise Vault
Information Governance
  • Todd_Anderson's avatar
    Todd_Anderson
    16 years ago
    Ok Tony sorry for not getting back to you earlier, but I opened a support ticket with Symantec and they had just called me back. We got it all resolved...Do you know if I will need to rebuild the indexes? The reason I ask this, is when i try and do a PST Migration using the wizard I get the error cannot find archive.

24 Replies

Sort By
Show More
  • Todd_Anderson's avatar
    Todd_Anderson
    Level 4
    16 years ago
    Tony,

    If we do decide to move SQL to its own server, what are the biggest things I need to watch out for? Do you know of a guide posted anywhere?

    Thanks,

    Todd
  • TonySterling's avatar
    TonySterling
    Moderator
    16 years ago
    There is this technote:

    http://support.veritas.com/docs/273272

    How to move an Enterprise Vault (EV) SQL directory and store databases from one SQL server to another.


    and Paul posted a great comment here:

    https://www-secure.symantec.com/connect/forums/ev-sql-database-movement

    He mentions these technotes


    http://support.veritas.com/docs/287521
    http://support.veritas.com/docs/281261
    http://support.veritas.com/docs/293852
    http://support.veritas.com/docs/293475

    Regards,


  • Todd_Anderson's avatar
    Todd_Anderson
    Level 4
    16 years ago
    Okay we successfully moved the databases and it all seems to be working except the fingerprint database. We have tried to run the sql script utility change the fingerprint DB but we keep getting this error in SQL...Any Ideas???

    Could not find the corresponding record to update SQL server name for the input fingerprint database.
  • Todd_Anderson's avatar
    Todd_Anderson
    Level 4
    16 years ago
    One other thing, it appears as if the Journaling task is not working properly. The mail is going to the journal mailbox and it shows them all in a pending state..What could be the problem with this?
  • TonySterling's avatar
    TonySterling
    Moderator
    16 years ago
    for Fingerprint is this what you used?


    http://support.veritas.com/docs/313277

    How to move a Fingerprint Database

    For the journaling, are your Vault Stores in Backup mode?

  • TonySterling's avatar
    TonySterling
    Moderator
    16 years ago
    Duh!  I just realized if the Fingerprinting is working right you might have issues with the journaling  if it is waiting on that.  :)
  • Todd_Anderson's avatar
    Todd_Anderson
    Level 4
    16 years ago
    Yes, we used the doc 313277...This is what we are trying to use anyway...When we enter the SQL command to run we get that error.
  • Todd_Anderson's avatar
    Todd_Anderson
    Level 4
    16 years ago
    I think the problem may be that we are not sure what names the script is looking for.

    Here is the command we changed.

    SELECT @vaultStoreGroupName = N'Express Vault Store',
    @fingerprintDBName = N'EVVSGExpressVaultStoreGroup_1_1', -- The name of the database that has been moved to a different SQL server
    @newSQLServerName = N'EVSQL' -- The name of the new SQL Server
  • TonySterling's avatar
    TonySterling
    Moderator
    16 years ago
    What is the name of your vault store group, fingerprint db and sql server?

    It doesn't say to change the vaultstore group name but I would think you need to.
  • TonySterling's avatar
    TonySterling
    Moderator
    16 years ago
    Also, this will give you the name of the Fingerprint DB.

    use enterprisevaultdirectory
    select * from FingerprintCatalogueDatabase