topic Single points of failure with enterprise geodatabase in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841208#M4666 <HTML><HEAD></HEAD><BODY><P>How do you avoid single points of failure with an enterprise geodatabase. We have a&nbsp;production geodatabase and publication geodatabase. We do have a solid backup and recovery plan in place and know how to use it.&nbsp;&nbsp;How do you keep your publication geodatabase constantly updated. It gets updated every night but in some cases that is not enough.</P></BODY></HTML> Wed, 25 Sep 2019 15:28:35 GMT ShannonSmith 2019-09-25T15:28:35Z Single points of failure with enterprise geodatabase https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841208#M4666 <HTML><HEAD></HEAD><BODY><P>How do you avoid single points of failure with an enterprise geodatabase. We have a&nbsp;production geodatabase and publication geodatabase. We do have a solid backup and recovery plan in place and know how to use it.&nbsp;&nbsp;How do you keep your publication geodatabase constantly updated. It gets updated every night but in some cases that is not enough.</P></BODY></HTML> Wed, 25 Sep 2019 15:28:35 GMT https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841208#M4666 ShannonSmith 2019-09-25T15:28:35Z Re: Single points of failure with enterprise geodatabase https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841209#M4667 <HTML><HEAD></HEAD><BODY><P>What is the RDBMS being used for the enterprise GDB side?</P><P></P><P>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.</P></BODY></HTML> Wed, 25 Sep 2019 20:58:25 GMT https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841209#M4667 George_Thompson 2019-09-25T20:58:25Z Re: Single points of failure with enterprise geodatabase https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841210#M4668 <HTML><HEAD></HEAD><BODY><P>SQL Server database, 10.6.1. These updates can occur when people are connected to it?</P></BODY></HTML> Wed, 25 Sep 2019 21:01:21 GMT https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841210#M4668 ShannonSmith 2019-09-25T21:01:21Z Re: Single points of failure with enterprise geodatabase https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841211#M4669 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>You may want to look into this with your DBA team to have better redundancy of the EGDB:&nbsp;<A class="link-titled" href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/connections-highly-available-sqlserver.htm" title="https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/connections-highly-available-sqlserver.htm">Connections to highly available SQL Server databases—Help | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Wed, 25 Sep 2019 21:10:33 GMT https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841211#M4669 George_Thompson 2019-09-25T21:10:33Z Re: Single points of failure with enterprise geodatabase https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841212#M4670 <HTML><HEAD></HEAD><BODY><P>Great, thank you for this.</P></BODY></HTML> Wed, 25 Sep 2019 21:13:18 GMT https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841212#M4670 ShannonSmith 2019-09-25T21:13:18Z Re: Single points of failure with enterprise geodatabase https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841213#M4671 <HTML><HEAD></HEAD><BODY><P>Hi Shannon,</P><P></P><P>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:&nbsp;<A class="link-titled" href="http://wiki.gis.com/wiki/index.php/GIS_Data_Administration#Production.2Fpublication_operations" title="http://wiki.gis.com/wiki/index.php/GIS_Data_Administration#Production.2Fpublication_operations">GIS Data Administration - GIS Wiki | The GIS Encyclopedia</A>.</P><P></P><P>Based on your description, it sounds like either geodatabase or DBMS-tier replication would be your best bets.&nbsp;<A class="link-titled" href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/scenarios-using-distributed-data.htm#GUID-6B73DA02-DD4A-4C65-BA8C-7B240FFE6BBA" title="https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/scenarios-using-distributed-data.htm#GUID-6B73DA02-DD4A-4C65-BA8C-7B240FFE6BBA">Scenarios using distributed data—ArcGIS Help | ArcGIS Desktop</A>. I haven't set this up myself but it seems to serve the need of what you're looking for. This blog might&nbsp;help you in your journey:&nbsp;<A href="https://community.esri.com/blogs/HackingArcSDE/2015/01/01/geodatabase-replicationwithout-the-replication-part-1">/blogs/HackingArcSDE/2015/01/01/geodatabase-replicationwithout-the-replication-part-1</A>&nbsp;</P><P></P><P>Good luck! Let us know how it turns out.</P><P></P><P>Micah</P></BODY></HTML> Wed, 02 Oct 2019 14:43:27 GMT https://community.esri.com/t5/geodatabase-questions/single-points-of-failure-with-enterprise/m-p/841213#M4671 MicahBabinski 2019-10-02T14:43:27Z