AnsweredAssumed Answered

Recommended SDE database maintenance in branch versioning environment

Question asked by brianmcleer on May 11, 2020
Latest reply on Oct 20, 2020 by abishop_ACPA

We are using branch versioning for the first time in an SDE database (SQL Server 2016). 


For our existing traditional versioning DBs, we use the recommended compress, rebuild indexes, and analyze datasets in our nightly routines similar to ESRI documentation below. This methodology is not recommended with branch versioning, however. 


Is anyone using certain GP tools on a regular basis for database maintenance for an SDE database that uses branch versioning? If so, what methods are you using? Do branch versioned DBs require daily maintenance as traditional versioned DBs require?


Enterprise geodatabase maintenance tasks—Manage geodatabases in SQL Server | Documentation