How do you avoid single points of failure with an enterprise geodatabase. We have a production geodatabase and publication geodatabase. We do have a solid backup and recovery plan in place and know how to use it. How do you keep your publication geodatabase constantly updated. It gets updated every night but in some cases that is not enough.
What is the RDBMS being used for the enterprise GDB side?
You can write and schedule Python scripts to update your publication database on a schedule. It would be based on the volume and how often the records would need to be updated.
Depending on the data and locks, yes. I am sure that many people here do this workflow. You would need to look at what is needed and build a script and test in your environment.
Sounds like you want your publication geodatabase updated in near real-time based on edits committed to your production geodatabase. I'd recommend reading through this section from Esri System Design Strategies, if you haven't already: GIS Data Administration - GIS Wiki | The GIS Encyclopedia.
