Mike Yearwood
Toronto, Ontario, Canada
Hi All
>>Moises,
>>
>>I wrote some years ago a backup program that backups open tables, the concept is quite easy thou, just open the table and copy to cdx <g> Granted, you will probably end up with data inconsistencies, but at least you get most of it. Of course there is no way you can copy a table that has been opened exclusively...
>
>Yes - copying to another table is probably the only way you will be able to do this. At least you *should* be writing complete records this way.
>
>Zipping has no way to know if the table or records are in a state where they are complete enough to write. If a zip program actually wrote a file, it very likely would be corrupt if users had the table open and were actively writing data..
In SQL Server there is the concept of replication. Triggers can copy records to other tables or better yet, have the trigger update a log. Have another process copy records listed in the log to the backup tables.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only