Re: Backup (was: Moving SE Database)

On Thu, 27 Aug 1998 18:58:13 GMT, axsander@okay.net (Axel Sander) wrote: >Hi, >I just checked out moving an SE 5.x Database to another partition. >Seems, like everything works OK. Now I'm thinking of adding the >complete database files to our daily backup for desaster recovery >(it's just 150 MB so no problem to compress them on the tape). Until >now we just run dbschema, unload all tables and output structure and >data to the tape. On a disk crash we rebuild the complete database >from scratch. But when moving an SE to a new partition is OK, a >restore of all *files* should do the same thing and save us hours of >rebuilding. Am I right? >What about restoring a single database file? Would it work if I stop >the database, restore the file and index files, kill the log and start >the database again? This works fine. It's your responsibility to make sure of database integrity of course. I am not sure what would happen if a foreign key relatioship would result from this, but assume it will not be detected until the relevent rows are accessed. I would also always run an integrity check at the tabel/index level useing becheck/secheck after any restore. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)