Creating a Single-file Shadow
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.