Weve been using Pervasive SQL for years and our backup routine has always been to close any apps accessing the database, copy the underlying data files out and then restart any of the apps. Restore is just as simple.
If you need to have the apps running and the database live at the time of backup, then you need to put the files into Continuous Operation Mode (basically makes delta files) and then copy out the files. I've never had to do this because our application is such that we can just tell users not to have it open for a while but here's some more info on it: http://ww1.pervasive.com/library/docs/psql/910/advops/advops-09-5.html >From what I understand, the Backup Agent is just a wrapper for the BUTIL -STARTBU and -ENDBU commands - Andy O. ________________________________________ From: Chris Blair [mailto:[email protected]] Sent: Monday, August 10, 2009 1:08 PM To: NT System Admin Issues Subject: OT:Pervasive SQL Backup Sorry for the OT. I need to backup and if needed restore a Pervasive SQL 7.5 DB. Does anyone have any experience doing this without the backup agent? ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
