You can exclude objects from any backup or restore job by amending excludeobjectinfo in the XML file containing the job definition.
- Open the XML file containing the job definition information.
-
Under excludeobjectinfo, specify the object name and object type that you want to exclude.
For example, to exclude tables T1 and T2 from a job that restores database ABC:
<objectinfo> <object_name>ABC</object_name> <object_type>DATABASE</object_type> <parent_name>SYSTEMFE</parent_name> <parent_type>DATABASE</parent_type> <!-- Optional --> <exclude> <excludeobjectinfo> <object_name>T1</object_name> <object_type>TABLE</object_type> </excludeobjectinfo> <excludeobjectinfo> <object_name>T2</object_name> <object_type>TABLE</object_type> </excludeobjectinfo> </exclude> </objectinfo>