Saving files with referential constraints

 

Referential constraints link multiple files together in a network, similar to the network for access paths. You might think of this as a relationship network. If possible, you should save all the files in a relationship network in a single save operation.

If you restore files that are in a relationship network during separate restore operations, the system must verify that the relationships are still valid and current. You can avoid this process and improve restore performance if you save and restore relationship networks in a single operation.

The Backup and Recovery book has more information about the considerations when restoring relationship networks.

 

Parent topic:

Saving database files