2,209
社区成员
发帖
与我相关
我的任务
分享TR@SOE: Restore backup Interbase?
This is my problem:
I´ve created a new field in a table that already had some records.
This field was defined as "not null".
The "not null field" in the existing records remained with a null value.
The interbase accepted my "alter table" issuing no error messages an my
database was working normally.
My customer continued working for days and was doing his backup in a dayly
basis. No error messages.
Some days later this database got corrputed and my customer tried to restore
de backup.
And here is the problem itself: IBConsole fails to restore the backup. When
IbConsole tries to restore the table with the "not null field" he complains
about the "empty not null fields" and aborts the restore process.
I would like to know if there is some way to restore ".gbk" file ignoring
this table with the not null field.
Or I could also try restore just one of the tables of the ".GBK" file and
not the entire database.
Is there any tool or component that can perform this?
Any kind of help would be apreciated. My customer is very unhappy and he is
a very important customer for me.
I´ve created a new field in a table that already had some records.
This field was defined as "not null".
The "not null field" in the existing records remained with a null value.
The interbase accepted my "alter table" issuing no error messages an my
database was working normally.
My customer continued working for days and was doing his backup in a dayly
basis. No error messages.
Some days later this database got corrputed and my customer tried to restore
de backup.
And here is the problem itself: IBConsole fails to restore the backup. When
IbConsole tries to restore the table with the "not null field" he complains
about the "empty not null fields" and aborts the restore process.
I would like to know if there is some way to restore ".gbk" file ignoring
this table with the not null field.
Or I could also try restore just one of the tables of the ".GBK" file and
not the entire database.
Is there any tool or component that can perform this?
Any kind of help would be apreciated. My customer is very unhappy and he is
a very important customer for me.
...全文
请发表友善的回复…
发表回复
yangguo_god 2002-12-07
- 打赏
- 举报
讨论着，讨论着，就开始比性欲了
hamzsy 2002-12-07
- 打赏
- 举报
Thank you, TR@SOE, thank you!
耙子 2002-12-07
- 打赏
- 举报
TR 写错了，应该是
“我靠！RP越来越不想活了。”
“我靠！RP越来越不想活了。”
TR@SOE 2002-12-07
- 打赏
- 举报
Maybe you can try "Deactivate Indices" set to true when you restore.
After restore, you use "alter index" to bring the index back to active state.
To All:
我不一定在书的后面整理FAQ，但是一定会在书当中就把一些问题连带着讨论掉。
To pazee/RomanticProgrammer:
嘿嘿，，嘿嘿。。。。
After restore, you use "alter index" to bring the index back to active state.
To All:
我不一定在书的后面整理FAQ，但是一定会在书当中就把一些问题连带着讨论掉。
To pazee/RomanticProgrammer:
嘿嘿，，嘿嘿。。。。
TR@SOE 2002-12-07
- 打赏
- 举报
我靠！越来越不象话了。
RomanticProgrammer 2002-12-07
- 打赏
- 举报
不过有TR大哥给我垫底,我倒是找到了安慰...啊哈哈.(他只有95啊)
RomanticProgrammer 2002-12-07
- 打赏
- 举报
pazee马上有两个星了吧?
delphi版是不是已经有两个星了啊.
delphi版是不是已经有两个星了啊.
RomanticProgrammer 2002-12-07
- 打赏
- 举报
to pazee:
好像是天生的吧...嘻嘻.
TR大哥的书什么时候出来啊.
好像是天生的吧...嘻嘻.
TR大哥的书什么时候出来啊.
耙子 2002-12-07
- 打赏
- 举报
RomanticProgrammer(兰企鹅)
加强锻炼，你行地！
等着 TR的书出来，到时候蹭本签名的。
加强锻炼，你行地！
等着 TR的书出来，到时候蹭本签名的。
RomanticProgrammer 2002-12-07
- 打赏
- 举报
我承认比不过pazee.....呜呜呜呜....真是可怜啊.
RomanticProgrammer 2002-12-06
- 打赏
- 举报
up!! 呵呵..
hamzsy 2002-12-06
- 打赏
- 举报
Thank you for your up!
invalid 2002-12-06
- 打赏
- 举报
怎么狠了啊，有好几个是我批准通过的在网络版。哈哈！
耙子 2002-12-06
- 打赏
- 举报
空心菜 狠呀！
我都不知道怎么弄得，进了12月份突然有3个FAQ被审核了。一下在自己都不适应了。
to 楼主
别生气，IB 这东西我们实在的不熟，你要等TR了，我们算作帮你UP了。
我都不知道怎么弄得，进了12月份突然有3个FAQ被审核了。一下在自己都不适应了。
to 楼主
别生气，IB 这东西我们实在的不熟，你要等TR了，我们算作帮你UP了。
RomanticProgrammer 2002-12-06
- 打赏
- 举报
hamzsy(十二真空间) :
我不会,等TR大哥吧..他是IB专家.
我不会,等TR大哥吧..他是IB专家.
RomanticProgrammer 2002-12-06
- 打赏
- 举报
Agree With Invalid.
invalid 2002-12-06
- 打赏
- 举报
正好可以删删pazee(耙子）的回复，给pazee(耙子)降降火啊！
hamzsy 2002-12-06
- 打赏
- 举报
You havn't answer my question yet.
RomanticProgrammer 2002-12-06
- 打赏
- 举报
我只有100...不是很行..玩了.我们谈论这些TR大哥看到了肯定气死了..呵呵.
耙子 2002-12-06
- 打赏
- 举报
RomanticProgrammer(兰企鹅)
你的意思是你不行吗？
你的意思是你不行吗？
加载更多回复（2）
