Moving the SQL DB to another SQL Server

Question

We are looking into a situation where the SQL Server currently being used for EmailXtender will be moved to an offsite location. Obviously, we will have to move the DB to another SQL Server on the LAN to avoid interruption of services. Is there a common procedure available for doing this? We're running 4.81.409, the SQL Server is running SQL2005.

RKatwal · Answer

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

jskoecher · Answer

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.

Moving the SQL DB to another SQL Server

Dell Support Resources

Latest Solutions

XPS 13 9315 2-in-1, need parts

Area-51, EVGA 3080 Ti, PSU question

After Bios updated 7320 instead of 7420

SATA Power

Can i upgrade my dell optiplex 7010mt legacy edition