Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Backup files
Message
 
À
29/02/2000 11:12:28
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvanie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00339024
Message ID:
00339166
Vues:
23
>>Don't need to do anything fancy. The main reason I'm adding this is that a (ahem, naive) user ran the Setup twice accidentally, and overwrote her data with new empty tables. Just in case someone does this again...most stuff we keep on servers with backups, but not these small local tables...
>
>What's in these small local tables? Could they be backed up to a server-resident database? Then you'd have a central way to manage the backups AND updates to the local files. The local files could be updated from the server with a parameterized view copied to the local table location. (the code could check if a table were empty, and fill it from the server's main/backup copy. The exit/backup routine could update the server table with any changes made during the session)

This is personal timesheet/leave data for each employee, hundreds of employees run the app off many servers, most of them unknown to me. I was initially keeping them on user server/mail drives at first, but found that these were sometimes re-configured, so that didn't cut it. I may take another look at that, see if it looks more stable now - and just use it for backups, not primary tables...that would get regular tape backups, at least - even if reconfigured, there should be something useful for a little while on tape.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform