Does Sage 500 have a mechanism to archive historic data that is no longer used

SOLVED

Over the years of use and lots of data imported from our various sales channels, our database has grown to about 80gb in size.  Maintenance on a database that big can be cumbersome when rebuilding indexes, doing backups, dbcc checks, et al . 

Is it possible to export / archive old data that we no longer need ?

  • 0
    verified answer
    I would suggest you work with your business partner to determine what tables are taking up the most space. You probably also want to backup your database before you do anything like this both to make sure you have reporting ability on things you decide to archive and for recovery if the results are not what you want.
    If you have been doing a lot of importing, you may find a logging table as one of the larger ones. There are internet resources showing queries to find the largest tables in your database.
    This task is very important to get right and our purge utilities don't always achieve what you want, so you definitely should do this against a copy of the database and have both SQL review of what's been archived as well as business experts in your company review the reports, queries and processing they do to determine if their critical data is still available.
    Some partners have developers purge utilities to help with this tough task.
    Sorry I don't have the easy answer for you.

    Darrick
  • 0 in reply to dbcoles
    SUGGESTED
    Thanks Darrick.
  • 0
    verified answer
    Although 80GB may sound big at first, it's not really that out of line in this day and age as many phones have even more storage. What I am suggesting is that you may find it more economical to upgrade the server to handle the DB better, than going through the effort of archiving data. With many clients in the similar situation, a $7-10K server upgrade or even less to something that has SSDs as the data/log drive easily solves the problem and provides added benefit of overall system performance boost as well.

    Just my 2 cents...
  • 0 in reply to John Lian
    This is the path we are on. I was just seeing if there was a builtin function as in MAS200 to do exports of old data.