07-20-2011 09:47 PM
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 on moving the DA database to the new server, and while I have found some they aren't clear, or maybe I'm reading it wrong. I'm looking at "Migrating Enterprise Vault to 64-bit hardware.pdf" as suggested in thread "https://www-secure.symantec.com/connect/forums/move-customer-database-different-sql-server"
The bit I'm having trouble is when you move the databases you have to open the Configuration database and tell DA about the new SQL server name:
Problem: I don't know how to open this page. I go to http://server/evbaadmin and I don't see Configuration Database page.
Can someone please advise how I see this?
Thanks.
Solved! Go to Solution.
09-08-2011 06:00 AM
You were really close, looks like you just missed step 8, you must have had to do this before! :)
Table Name | Column | Value |
---|---|---|
tblCustomer | Server | New_SQL_NetBiosName |
07-21-2011 01:15 AM
Hell Mate,
Have you referred to Symantec Technote:
http://www.symantec.com/docs/S:TECH78528 - How to move version 8.x or 9.x Discovery Accelerator (DA) and Analytics databases.
Let me know if you need further assistance.
07-24-2011 03:47 PM
Hi,
I have looked at it. That document is for relocating databases which are on the same SQL server, so the server name will not change. I am trying to move them to a new server with a different server name.
07-25-2011 06:47 AM
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
07-27-2011 03:53 PM
So that would get DA working, I've noticed that the Customer Databases were still pointing to the old SQL server. I edited the Config database Customer table and change the SQL server listed there to the new one, is there anything else I need to do?
Cheers,
07-27-2011 04:00 PM
I spoke with someone from Symantec, they advised to uninstall DA, move DBs, reinstall and point at old config database. What are the merits of either method (reinstall VS edit of config files list above)? Above method seems easier...He didn't mention anything about Customer databases, so will go back to him and ask.
09-08-2011 05:59 AM
Here is the technote you can use to move the sql db's http://www.symantec.com/docs/TECH51129
No need to uninstall/reinstall.
09-08-2011 06:00 AM
You were really close, looks like you just missed step 8, you must have had to do this before! :)
Table Name | Column | Value |
---|---|---|
tblCustomer | Server | New_SQL_NetBiosName |
09-14-2011 07:53 AM
Tony is correct in that you don't need to uninstall and reinstall. If fact, if you're not moving DA to a new server, that process won't update all of the places that need updating when the databases change to a different SQL Server or SQL instance. The steps Paul (Florida57) and Tony provided are the correct steps.
When moving all of the DA databases, you must ensure that the DA configuration database is updated wtih the new SQL Server name (and instance if installed on an instance). This name change is to the tblCustomer table that contains references to all of the DA Customers that have been configured. This table includes 1 row for each DA Customer, with the SQL Server NetBIOS name (and instance) referenced for access to that customer's database.
The reason the exe.config files must be updated is these files refer to the DA Configuration database and are read when the Enterprise Vault Accelerator Manager Service (EVAMS) is started. As part of the service startup, a communications channel between the DA and SQL servers is established, so these files provide the proper information for that connection.