Subject Re: Firebird 1.0.3, How to drop file from multifile database?
Author brohughman
--- 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