Using CREATE SHADOW
Go Up to Creating a Database Shadow
Use the CREATE SHADOW statement to create a database shadow. Because this does not require exclusive access, it can be done without affecting other users. A shadow can be created using a combination of the following options:
- Single-file or multifile shadows
- Auto or manual shadows
- Conditional shadows
These options are not mutually exclusive. For example, you can create a single-file, manual, conditional shadow.
The syntax of CREATE SHADOW is:
CREATE SHADOW set_num [AUTO | MANUAL] [CONDITIONAL] 'filespec' [LENGTH [=] int [PAGE[S]]] [<secondary_file>];
Where:
<secondary_file> = FILE 'filespec' [<fileinfo>] [<secondary_file>]
<fileinfo> = {LENGTH[=]int [PAGE[S]] | STARTING [AT [PAGE]] int } [<fileinfo>]