x Want to participate? Join the group to interact
  • State Suggested Answer
  • +3 person also asked this people also asked this
  • Replies 8 replies
  • Answers 1 answer
  • Subscribers 140 subscribers
  • Views 1878 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
211
topics
418
replies
Sage Intelligence Reporting
121
topics
322
replies
Martin Bean - 4CAD

Archiving & Purges

SUGGESTED
Posted By

Hello Sage City,

As a Sage partner, I have heard numerous horror stories about the "PURGE" function in older v5, v6 and v7 versions of Sage X3.

A customer of mine will be migrating to v12 shortly and asked about purging old data from the database to regain disk space.

My last personal experience with a data purge ended with a DB restore as we had multiple errors in X3. 

I'd like to hear about your experiences and recommendations regarding archiving and purging data from older version.

Cheers,

Martin

Parents
  • 0

    I am interested on the horror stories of the "PURGE" function. Please do share some out.

    For archiving, I noticed a client requested me to create a duplicate folder of the currently running production folder yearly.

    Then they maintain from their end to clear out non-essential data for the new year manually and slowly archiving the old production folder and removing from X3 once done to actual archive drive.

    For purging, if it is just the logs, I did a clear table from table screen.

    I did managed to kill a database because of an extreme purge run (X3 logs size was x3 of X3 masterdata) which the SQL Server log file (it was set on Recovery Model: FULL) was not built to account for such the edge case without prior heads-up.

    Masterdata purge I have no experience so I am interested in how everyone did for those along with archiving activities.

Reply
  • 0

    I am interested on the horror stories of the "PURGE" function. Please do share some out.

    For archiving, I noticed a client requested me to create a duplicate folder of the currently running production folder yearly.

    Then they maintain from their end to clear out non-essential data for the new year manually and slowly archiving the old production folder and removing from X3 once done to actual archive drive.

    For purging, if it is just the logs, I did a clear table from table screen.

    I did managed to kill a database because of an extreme purge run (X3 logs size was x3 of X3 masterdata) which the SQL Server log file (it was set on Recovery Model: FULL) was not built to account for such the edge case without prior heads-up.

    Masterdata purge I have no experience so I am interested in how everyone did for those along with archiving activities.

Children
No Data

*Community Hub is the new name for Sage City