Creating a Single-file Shadow (Using CREATE SHADOW)

Go Up to Using CREATE SHADOW

To create a single-file shadow for the database employee.ib, enter:

CREATE SHADOW 1 'employee.shd';

The shadow is associated with the currently connected database, employee.ib. The name of the shadow file is employee.shd, and it is identified by a shadow set number, 1, in this example. The shadow set number tells InterBase that all of the shadow files listed are grouped together under this identifier.

To verify that the shadow has been created, enter the isql command SHOW DATABASE:

SHOW DATABASE;
Database: employee.ib Shadow 1: '/usr/interbase/employee.shd' auto PAGE_SIZE 1024 Number of DB pages allocated = 392 Sweep interval = 20000

The page size of the shadow is the same as that of the database.