Clarification on Selective Backups [CR #630990]

Update the third example in SQL Statements > RESTORE Statement as follows:

A selective backup backs up either all READWRITE dbspaces or specific read-only dbspaces or dbfiles. READWRITE backups are a subtype of either full or incremental backups.

Notes:

• You can take a READONLY selective backup and restore all objects from this backup (as in the second example above).

• You can take an all-inclusive backup and restore read-only files and dbspaces selectively.

• You can take a READONLY selective backup of multiple read-only files and dbspaces and restore a subset of read-only files and dbspaces selectively. See “Permissions.”

• You can restore the read-only backup, only if the read-only files have not changed since the backup. Once the dbspace is made read-write again, the read-only backup is invalid, unless you restore the entire read-write portion of the database back to the point at which the read-only dbspace was read-only.

• Sybase recommends that you use one backup subtype, either selective or non-selective. If you must switch from a non-selective to a selective backup, or vice versa, always take a non-selective full backup before switching to the new subtype, to ensure that you have all changes.