Forum Discussion

Matthew_J's avatar
Matthew_J
Level 4
8 years ago

Moving DA databases

We want to move our Discovery Accelerator databases from one SQL server (SQLOLD\Vault) to a new SQL server (SQLNEW\Vault).  We don't use Compliance Accelerator at all, just DA. I'm trying to work out...
  • TechMerc's avatar
    TechMerc
    8 years ago

    In answer to your additional question:

    As I mentioned, the Configuration DB is a part of DA, and you'll likely want to move that to the new SQL server, particularly if you're retiring it. DA can't work without that database.

    I have my own method of moving DA databases which I find to be much simpler.  It's basically this:

    1. Shut down DA services and copy the databases to the new server
    2. Uninstall and reinstall DA
    3. Point the browser to the EVBAAdmin page to perform initial configuration.  This is the point where it either configures a new config database or attaches to an old one.  Enter the new SQL Server name and Config database name and check the 'Existing Database' check box.
    4. After you restart services, you should see your custodian and customer databases on the page.
    5. Edit each of the databases (custodian and customer) and change the SQL server name.

    You should be good to go after that.

Matthew_J's avatar
Matthew_J
Level 4

There's definitely a schema change for CHF3, I can confirm that I had to update the CustodianManager and other customer DB as part of the install process.  Additionally, when I installed CHF3 on our vault server, I neglected to put the EV databases in simple recovery mode and our log files blew up to enormous growth (10 gigs per hour or so) after the CHF3 update.

Anyway, that's unrelated to all this.  But, thank you very much for your help TechMerc, I really appreciate it.

TechMerc's avatar
TechMerc
Level 4
8 years ago

Any time!  Hope the move goes smoothly for you.

  • Matthew_J's avatar
    Matthew_J
    Level 4
    8 years ago

    To follow up, the move did go mostly smooth but I did have to roll back and restart the process once due to the main customer DB not wanting to restore onto the new server (I'll get to that in a minute).  I did just about the exact steps you mentioned.  I stopped all services, backed up the db's from the old SQL server, restored them to the new SQL server.  Once I was satisified there, I took a snapshot of the DA server, then I went in and uninstalled the DA server components from the DA server.  Then I started the 10.0.4 DA install, let it finish, and then installed the CHF3 update.  Once that was done, I loaded the EVBAAdmin site, selected existing database, and pointed it to the new location.  After that, all I had to do was modify the CustodianManager db properties and the main customer db properties in the EVBAAdmin to point them to their new locations, and I also had to change the "Full Text index" location for the main customer DB in the properties.

    The one problem I ran into, when restoring the backup of the main customer DB was that it was complaining about files that were already there (A folder related to full-text indexing).  First, I thought that maybe I had left a case with analytics enabled, so I backed out of everything, restarted the services, loaded the DA client and went to investigate and found that there were no cases with analytics enabled.  I went ahead and closed all of the cases we had, since they were no longer in progress, and deleted a bunch of research items out.  I stopped services again and backed up the DB again, and tried the restore and had the same problem.  So, I went ahead and checked the "Restore with overwrite" option, and that did the trick.  I don't know if we had attempted to load this DB before on this instance and left some stuff behind or what, but it restored fine after that and we are up and running.

    Thanks again for your help TechMerc. 

    • TechMerc's avatar
      TechMerc
      Level 4
      8 years ago

      It's always something, isn't it? :smileylol:

      Thanks for the follow-up.  It's good to know how things worked out.  Congratulations on the successful move!

      • Dan_A1's avatar
        Dan_A1
        Level 4
        3 years ago

        Have you tried the same process for the EV databases?