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

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

Hi John,

Would you be willing to share your PowerShell script?