<< Is anyone using a backup procedure that would allow you to be up to the hour? >>
I have one client where we run a "robot" process that generates various reports and performs other actions automatically during the day. One of the things the robot does is a daily backup of the database using UNLOAD. I've been toying with making the process more frequent than once a day. The problem is getting your database into sufficiently good shape that an UNLOADed database can be recreated simply by running the unload file. Problems I've seen are views that contain variables in their definitions (can't be recreated), views that get "out of order" in the database so that R:Base unloads a dependent view first and then the view that it depends on, and odd issues with foreign keys. But in principle, once you have an unloadable database, you ought to be able to back it up every few minutes if you want to. The trick is to use one of the R:Base commands that backs up the _attached_ database -- that way it will work with other users connected. -- Larry
