Backup Indexes

michel.weber · Post by **michel.weber** » Wed Jun 22, 2011 4:19 pm

Is there a way to do a proper Backup of a TEXIS database.

It currently takes over a week to rebuild our main indexes, and i don't feel very compfortable not having a quicker solution to restore a DB.

Post by **mark** » Wed Jun 22, 2011 4:43 pm

It's mainly up to you to use your favorite backup scheme to backup everything in the database directory and other directories you may have specified with tablespace and indexspace.

For a database that large it might be good to use some kind of snapshot functionality of the OS so you can backup the snapshot without keeping the database locked for the long period of time it might take to copy everything off to external media.

There's a utility command called lockandrun, http://www.thunderstone.com/site/texism ... ndrun.html , that can be used to ensure the database doesn't change while backing it up.