the easiest way is...
1) Stop EPO Services
2) Copy the Database and Database LOG Files to the new SQL Server.
3) Attach the Database to the new SQL Server.
4) Configure a user who is dbowner of the EPO Database
5) Start the EPO Tomcat Service only
7) change the database settings
8) restart any EPO server service
9) check the EPO server Logs if there are any error.
Hope this helps,
forgot there is a difference if moving between two external SQL servers or from a local SQL server to a remote SQL server.
Need assistance w.r.t. ePO 5.1 Application server backup and it's database backup and Security updates
- How to restore the ePO server using server snapshot
- How to backup and restore ePO Database which is separate database server
- If in case Clients IP gets changed what will happen : Will they communicate to ePO server and update policies and DATs automatically: Do I need to do ''Wake up agent" on all clients
- We are having mixed environment: VMware and Hyper-V : It has been noticed that few VMs are getting updated automatically but few were not,I need to update them manually. How to comply 100% updation
Answers to some of your questions:
#2. This depends on your organization and if you are using the full or simple recovery model within SQL. For backup, once you determine your recovery model, just create a maintenance plan or job to perform the backup. For restoring, Troja covered it in his original reply.
#3. There is no ffect when changing IP, it will still try and go to whatever is listed via policy and in the Sitelist.xml
I put together the attached DB overview for ePO a while ago, you could go through it and see if there might be anything usefull in it to help with your DB setup.
ePO DB Performance v1.1.docx 144.7 K