Then if the archive proves unusable or has other problems that make it suspect, the data is in the temporary files and, with some effort, can be salvaged. Possibly store them in a file-archiving system. You might want to keep the temporary files around for a longer period of time. This includes creating any archive data store backups. After a few extract executions, the space requirement should become clear.ĭo not delete temporary files or tables until you are positive that the data on them has been safely put away in the archive. You can use statistics to determine how much temporary space is needed. You don't want to get an out-of-space interruption. Most DBMSs do dual logging for exactly the same purpose.īe sure that enough space is available before starting execution. This way an error in reading a file cannot cause loss of data. It is a good idea to always create dual files, separating them on different disk drives. If temporary files or tables are used to separate processes, they must be managed carefully. Olson, in Database Archiving, 2009 15.4.4 Workspace Management
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |