Replication vs. direct edits in sde and how it affects transaction log

654
1
10-20-2016 02:38 PM
DanielWebb2
New Contributor III

Hello all,

I work for a county government and we are trying to determine the best way forward with an issue.

 

We have two employees who edit parcel data full time directly in the SDE database.  This makes the transaction log in SQL fill up really quick.  Recently it has caused errors because it got full.  Is this because they are editing the SDE data directly?  Eighty hours a week of edits seems like a lot of transactions to log (if I understand things right).

 

So we are talking about switching to replication so they would edit a replica of the data and then it would synchronize at the end of the day (either manually or by script).  Would this decrease the transaction log?  In other words, would there be one transaction for the synchronizing OR would the synchronization still maintain all their transactions in the replica and log all of them during synchronization?

 

The people who set this system up are no longer here and those of us left have only rudimentary knowledge of SQL and how it all works.

 

Thank you for any advice.

0 Kudos
1 Reply
George_Thompson
Esri Frequent Contributor

Hi Daniel,

This is really a question about how much "coverage" you want to have in regards to disaster recovery of your SQL Server database. There are different recovery methods in SQL Server that can be used. The transaction log is not an Esri controlled piece of the SQL Server.

Here are some good links to start looking at managing the transaction log files:

sql server - Why Does the Transaction Log Keep Growing or Run Out of Space? - Database Administrator... 

Recovery Models and Transaction Log Management 

https://msdn.microsoft.com/en-us/library/ms365418(v=sql.105).aspx 

Shrinking the Transaction Log 

Hope these help point you in the correct direction.

https://community.esri.com/community/gis/managing-data?sr=search&searchId=db92bac8-9c88-40a9-83ef-d1...https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=53109057-c6b6-4ff9-a3fa-b...

--- George T.