Helen,
I ran the backup and it hickup'd again.
Yesterday I created a multifile database, 41 files each file
containing 40000 pages, each page 16K, use all space. I noticed that
the last page was almost to 640MB so I made 10 more files this am
through IB_SQL.exe using ALTER DATABASE AD FILE '.....42.gdb' LENGTH
40000; and then noticing that my backup last night didn't go off, I
ran the backup which erased my good backup.
I was wondering if I could tell the database to drop the files I
added, since I haven't added anything new to the database and get on
with things?

Hugh


--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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