Subject | Re: [ib-support] Re: WRONG PAGE TYPE IB6 ODS10 |
---|---|
Author | Helen Borrie |
Post date | 2002-09-08T22:24:11Z |
At 08:54 PM 08-09-02 +0000, you wrote:
filesystem copy programs. GBK files (backups created by the GBAK program)
are highly portable.
you risk corruption - there are very few ways you can corrupt a FB/IB
database and this is one of them. It's not just that the backed up file
will be inconsistent (because it will have changed before the copy is
complete) but Windows file-copying mechanisms actually lock sectors of the
disk during the copy, preventing the database engine from completing its
writes.
Moreover, if your customer is never using gbak, then there is important
periodic housecleaning that will never get done.
All that said, where does the error in the thread's title come in - "WRONG
PAGE TYPE IB6 ODS10" ? With IB 6 you can't open a database that was
created on a lower IB version...Firebird, however, will open, read from and
write to a 5.x database with a smile on its face.
heLen
>I am intrested though why moving a GDB should be an issue as IGDB files are not designed to be portable, nor to be backed up by
>understand it a GDB is extremely portable and infact I often have to
>move the physical location of GDB's on sites.
filesystem copy programs. GBK files (backups created by the GBAK program)
are highly portable.
> > Have you being doing regular backups and restores over this lastWhat do you mean by "an IB agent"?
>year?
>Yes the Client has been doing backups. However against my advice
>they have not been using backup software that has an IB Agent.
>TheIf a filesystem copy backup program is used whilst a database is running,
>result has been that the actual backups have not been good. Yes and
>the Client does now except that the should be checking their backups.
you risk corruption - there are very few ways you can corrupt a FB/IB
database and this is one of them. It's not just that the backed up file
will be inconsistent (because it will have changed before the copy is
complete) but Windows file-copying mechanisms actually lock sectors of the
disk during the copy, preventing the database engine from completing its
writes.
Moreover, if your customer is never using gbak, then there is important
periodic housecleaning that will never get done.
All that said, where does the error in the thread's title come in - "WRONG
PAGE TYPE IB6 ODS10" ? With IB 6 you can't open a database that was
created on a lower IB version...Firebird, however, will open, read from and
write to a 5.x database with a smile on its face.
heLen