Creating a Single-file Shadow

From InterBase
Jump to: navigation, search

Go Up to Creating a Shadow


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

SQL> CREATE SHADOW 1 '/usr/InterBase/examples/employee.shd';

The name of the shadow file is employee.shd, and it is identified by the number 1. Verify that the shadow has been created by using the isql command SHOW DATABASE:

SQL> SHOW DATABASE;
Database: employee.ib
Shadow 1: '/usr/InterBase/examples/employee.shd' auto
PAGE_SIZE 4096
Number of DB pages allocated = 392
Sweep interval = 20000

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

See Also

Advance To: