Moving the SQL DB to another SQL Server

Hi,

Usually this kind of job goes to EMC Professional Services department, they can do it for you. Otherwise check with support if they can help but mostly they will refer to professional services teams.

Thanks,
Rajan

Hi rb17,

I've done this previously. EMC isn't keen on having SQL on a separate machine. They fear performance problems and I didn't get much help out of them!

Stopp all EX services and disable them.
Backup DBs EmailXtender + ExAudit.
Use the DB backups and load them on the new SQL server.

#### on the new SQL server ####
- create a user ExArchiveUser (password: ExArchiveUser) and ExAuditUser (password: ExAuditUser) in SQL
- Set the two users as dbowner on its database (exArchiveUser on the db EmailXtender, and ExAuditUser on the database ExAudit).

#### on Emailxtender server ####
- Ex services are still stopped.
- Change registry (HKLM\SOFTWARE\OTG\EmailXtender, HKLM\SOFTWARE\OTG\EmailXtender Audit) to the new DB server.
- change the Data Sources (ODBC) > System DSN (tab) to the new SQL server and test with the users (see above).
- we got an error in the event log: Error Performing Socket Bind. Error Code: 203 which we solved with "esg92814" Reserving TCP/IP ports for use by EmailXtender!
- Restart the server.
- Everything is working!

---------------------------------------------
Alternatively, after changing the SQL db and create the new users/owners on the db, you could reinstall EX. In the EX installation routine, you have the option to use existing SQL dbs (kind of an EX update). This is also working well. As part of the installation routine, the odbc connection is set up for you.

So, moving dbs is definitely possible! Hope the info helps.

Kind regards,
Jochen.