Re: Backup & Restore Granularity
In article <32E8C9E4.167E@genacc-us.com>,
Paul Reimold <preimold@genacc-us.com> wrote:
>I am fairly new to Informix admin. I was surprised (and disappointed) to
>learn that On-Tape, On-Archive (and, I believe the up-coming On-Bar)
>back up and restore only at the dbspace level. WHY NOT AT THE TABLE
>LEVEL?
>
>If a user is in dbaccess, it is frightlenly easy to drop a table.
>Indeed, the term 'drop' implies to me that one simply does not want to
>work with a table any more, not the more serious action of blowing it
>away!
>
>Other than assigning a dbspace to each table, is there any other way to
>backup/restore individual tables?
>
Don't grant DBA to users and they can't drop a table.
We put our large tables in their own dbspace. The smaller tables will go in a
single dbspace. Then we will unload the smaller tables regularly(weekly,
daily) just in case I drop the table or the user deletes everything in the
table.
Matt Bentley
mbentley@xmission.com