Backup Questions

Question

I am trying to determine the best possible backup solutions for Sage 300 CRE. 
 
 Is it possible to restore single Sage files from a Microsoft Shadow Copy? If so, what is the correct way to do that without disrupting the database? 
 
 Is it possible to automate the Sage backup feature?

John McLagan · Answer

Hi Randy - 
 I would be very careful with using Shadow Copy restores with any relational database. You could for example, restore a new.prt file from a shadow copy if you haven't printed or generate direct deposits. Because the data is all contained in that single file with no supporting entries being created in CM or GL yet (assuming you don't have SM time being sent to PR). So using Shadow Copy restores or any active backup solution that doesn't take the pervasive engines offline prior to backup, has the potential of corrupting the database as a whole. 
 I usually write a powershell script that runs nightly. It takes the Pervasive and Sage Framework services offline, in essence kicking everyone out of the database and copies the Data Folders to a "Workfile" location. Then turn back on the services, this minimizes down time. Then I usually perform a compression routine on the Data Folders in the "Workfile" location and move it to an archive. Monthly, I would do the same routine, but include folders in the 9.5 share that have the potential of data being changed on a much less frequent schedule. I.E.-Formulas, Reports. 
 Good Luck, 
 John McLagan Sage Consultant Johnny on the Spot

Sage Construction & Real Estate

Backup Questions

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING