Backup Indexes

Post Reply
michel.weber
Posts: 256
Joined: Sat Oct 08, 2005 12:40 pm

Backup Indexes

Post by michel.weber »

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.
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Backup Indexes

Post by mark »

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.
Post Reply