At 04:09 PM 16/10/2003 +0000, you wrote:

>Hello,
> I have large problem. I created more files for my database
>and
>unfortunately they are the wrong type (1 instead of 8).

No, that's not what it means, I think...

>My backup
>stops and complains that the database is corrupt because page 164001
>is the wrongtype 8 instead of 1.

It sounds as if page 164001 might be the first page of a secondary file,
i.e. you have a primary file of 164000 pages and a secondary file STARTING
AT 164001.

If so, were you trying to back up the secondary file individually? That's
NOT what you do.

If this is the case, simply start the backup again and don't mention the
name(s) of the secondary file(s) in the gbak -b statement. The primary
file's header contains the paths to the secondary files and gbak knows what
to do with them.

Only do

gbak -b /path/to/YourPrimaryDBname.fdb /path/to/YourBackupFileName.fbk
-user sysdba -password xxxxxx

DON'T TOUCH SEC. FILES AT FILESYSTEM LEVEL AT ALL!!!
If/when you restore, you can recreate multiple database files or recreate
as a single file, your choice.

heLen

>Since these added files are not
>being used yet is there a command, I couldn't find one, that will
>allow me to drop them from the database?

See above. READ THE DOCS.

>Thanks and pardon my stupidity,

You're pardoned.
;-)
heLen