Subject | Re: Firebird 1.0.3, How to drop file from multifile database? |
---|---|
Author | brohughman |
Post date | 2003-10-16T17:45:38Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
wrote:
> At 04:09 PM 16/10/2003 +0000, you wrote:164001
> >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
> >is the wrongtype 8 instead of 1.file,
>
> It sounds as if page 164001 might be the first page of a secondary
> i.e. you have a primary file of 164000 pages and a secondary fileSTARTING
> AT 164001.That's
>
> If so, were you trying to back up the secondary file individually?
> NOT what you do.mention the
>
> If this is the case, simply start the backup again and don't
> name(s) of the secondary file(s) in the gbak -b statement. Theprimary
> file's header contains the paths to the secondary files and gbakknows what
> to do with them.b /path/to/YourPrimaryDBname.fdb /path/to/YourBackupFileName.fbk
>
> Only do
>
> gbak -
> -user sysdba -password xxxxxxrecreate
>
> DON'T TOUCH SEC. FILES AT FILESYSTEM LEVEL AT ALL!!!
> If/when you restore, you can recreate multiple database files or
> 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