Who Can Create a Shadow
The CREATE SHADOW
statement can be executed by:
-
Users with the
ALTER DATABASE
privilege
The CREATE SHADOW
statement can be executed by:
Users with the ALTER DATABASE
privilege
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';