Subject | Index error |
---|---|
Author | Michael Vilhelmsen |
Post date | 2004-02-02T14:35:26Z |
Hi
Please ignore my earlier posting today regarding GBak error.
I'll do a bit more explaining here.
I have a Backup file from a customer.
The originally
DB is up and running and has been for quite some time.
Each night we are making a backup with GBak.
I just took hold of the backup file this morning to do some research
in the data locally.
I can ONLY restore the DB if I do NOT active any index !
Then afterwards I can active any index' NOT involving foreign keys.
I can DELETE any foreign key already defined.
But what I can't do is:
- Active ANY foreign key reference !
- Make ANY new foreign keys !
Right now, there is no problems, since the original DB is up and
running.
But if I don't find this error, I think I will get into trouble in
the future.......
Michael
Please ignore my earlier posting today regarding GBak error.
I'll do a bit more explaining here.
I have a Backup file from a customer.
The originally
DB is up and running and has been for quite some time.
Each night we are making a backup with GBak.
I just took hold of the backup file this morning to do some research
in the data locally.
I can ONLY restore the DB if I do NOT active any index !
Then afterwards I can active any index' NOT involving foreign keys.
I can DELETE any foreign key already defined.
But what I can't do is:
- Active ANY foreign key reference !
- Make ANY new foreign keys !
Right now, there is no problems, since the original DB is up and
running.
But if I don't find this error, I think I will get into trouble in
the future.......
Michael