Forum Discussion

Sortid's avatar
Sortid
Level 6
13 years ago

Move DA Database

Using EV8Sp5 and also 9SP2 (two separate installations).  I have set up a SQL 2008 server to host the EV and DA databases.  They currently sit on SQL 2005 servers.  I am trying to find instructions o...
Discovery Accelerator
Information Governance
  • TonySterling's avatar
    TonySterling
    13 years ago

    You were really close, looks like you just missed step 8, you must have had to do this before! :)

    8. Modify the following in the CA or DA Configuration database. Replace the original SQL_NetBios server name with the new SQL_NetBios server name.
     
    Table Name Column Value
    tblCustomer Server New_SQL_NetBiosName
    Open SQL Query Analyzer and run the following query separately against each Configuration database that has been moved.  Replace bold items with the correct server name values:
    UPDATE tblCustomer SET Server = 'New_SQL_NetBiosName' WHERE Server = 'Old_SQL_NetBiosName'
Paul_C_'s avatar
Paul_C_
Level 3
13 years ago

Heres how I would do it

 

first - before you move any DBs

go into DA and accept/reject any pending search results.

and stop and reject any running searches or let them finish and accept/reject

then stop the Accelerator manager service on the DA server

 

then you are ready to move the SQL DBs

the DA config DB and the  customer DB etc

detach the DB

move it to new SQL server attach etc

then go into the  da config files on the DA server  -in the pgm files /business accelerator folder

theres 4 config files

accelmgr.exe.config

accel console exe config

accel service.exe config

and adsync exe config

(and poss some analytic config files)

 

open them in notepad and look for the line  with the SQL server name

it will look like this    <add key="DSNConfiguration" value="server='YOUR SQL SERVER';Integrated Security=true;Initial Catalog='EVDAConfiguration';Connection Timeout=100;Connection Lifetime=30;Max Pool Size=200" />

If your SQL server name is different  from the original then you change it there.

also make sure the new SQL server is in your DNS etc

 

Rgds

Paul