Who Can Create A Shadow

Who Can Create a Shadow

The CREATE SHADOW statement can be executed by:

Administrators
Users with the ALTER DATABASE privilege

Examples Using `CREATE SHADOW`

Creating a shadow for the current database as “shadow number 1”:
```
CREATE SHADOW 1 'g:\data\test.shd';
```

Creating a multi-file shadow for the current database as “shadow number 2”:

CREATE SHADOW 2 'g:\data\test.sh1'
  LENGTH 8000 PAGES
  FILE 'g:\data\test.sh2';

See also

[fblangref50-ddl-db-create], [fblangref50-ddl-dropshadow]