We need to keep in mind that a database is a single recovery unit by
definition. There is no object-level backup/restore,and there would be
serious integrity problems if such were provided, so do not look for
it. But there are facilities that can be used.
Some of us have been providing object level backup and restoration for
large tables for years (before the Archive Database Feature, which is
good, but it is a different thing). As a part of the backup regime,
bcp-out said tables; use -F etc to constrain rows; use a view to
constrain currency (if you have a database with Optimistic Locking,
last-updated timestamps, you can extract just the rows that have
changed). You need to quiesce the activity (I was doing it before the
advent of Quiesce command, I have not changed and tested my code with
that), and execute the backup in the correct order of tables. How/what
you restore depends on what diffs you find, which usually means loading
the restore into another Db, so that you can compare the sets of rows
easily via SQL.
If this becomes a regular or structured activity, you can look into
splitting the Db. Eg. Reference and large unchanging tables in one DB;
transaction tables in another (with full DRI).
SQL BackTrack is a 3rd party product that provides the object-level
backup/restore facility, but very few people used it.
Senior Sybase DBA / Information Architect
Copyright © 2008 Software Gems Pty Ltd
Tired of databases that are more cost than benefit ? Wondering why you
cannot get Sybase performance from Sybase ? Find out