救命！为什么我的数据库会不断破坏？ [英] HELP! Why does my database keep corrupting?

问题描述

我有一个用于后端和前端的数据库拆分和我的后端（我的

数据）最近像疯了一样腐败。今天我们已经压缩了

并在一小时内修复了4次。这个数据库并没有经历很多膨胀。过去我们曾经有过这样的实例：数据库已经达到了200,000KB，之后又需要对b
进行压缩和修复。在C& R之后它通常是31,700 KB。

最近当它达到大约40,000KB时我们需要C& R - 这不是一个

整批臃肿今天，它没有能够在没有腐败的情况下获得超过32,000KB的价值。我们不断收到

无法识别的数据库格式的消息。有没有人有任何见解？我不能像这样继续这个 - 它是一个生产支持数据库。当

下跌时，我们会失去宝贵的时间和金钱。


谢谢！


Pamela DeVries

I have a database split for back end and front end and my back end (my
data) has been corrupting like crazy lately. Today we have compacted
and repaired like 4 times within an hour. The database is not
experiencing a lot of bloat. We have had instances in the past where
the database has gotten up to 200,00KB before indicating it needed to
be compacted and repaired. After C&R it is usually at 31,700 KB.
Lately when it gets to about 40,000KB we need to C&R - that''s not a
whole lot of bloat. Today it hasn''t been able to get over 32,000KB
without corrupting. We are constantly getting messages of
"unrecognizeable database format". Does anyone have any insight? I
can''t continue like this - it is a production support database. When
it is down we lose valuable time and money.

Thanks!

Pamela DeVries

推荐答案

检查是否对网络进行了任何硬件更改，并查看更改的时间是否为
配合腐败突然增加

问题。


特里


" PamelaDV" < PD ****** @ steelcase.com>在消息中写道

news：b6 ************************** @ posting.google.c om ...

Check to see if any hardware change have been made to the network and see if
the timing of the change(s) tie in with the sudden increase in corruption
problems.

Terry

"PamelaDV" <pd******@steelcase.com> wrote in message
news:b6**************************@posting.google.c om...

我有一个后端和前端的数据库拆分和我的后端（我的
数据）最近像疯了一样腐败。今天我们已经在一小时内完成了4次压缩和修复。数据库没有经历太多膨胀。过去我们曾经有过这样的实例，数据库已经达到200,00KB，然后才需要进行压缩和修复。在C& R之后它通常是31,700 KB。
最近当它达到大约40,000KB时我们需要C& R - 这不是一个很大的膨胀。今天它没有能够超过32,000KB
而不会腐败。我们不断收到无法识别的数据库格式的消息。有没有人有任何见解？我不能继续这样 - 它是一个生产支持数据库。当它关闭时我们会失去宝贵的时间和金钱。

谢谢！

Pamela DeVries

I have a database split for back end and front end and my back end (my
data) has been corrupting like crazy lately. Today we have compacted
and repaired like 4 times within an hour. The database is not
experiencing a lot of bloat. We have had instances in the past where
the database has gotten up to 200,00KB before indicating it needed to
be compacted and repaired. After C&R it is usually at 31,700 KB.
Lately when it gets to about 40,000KB we need to C&R - that''s not a
whole lot of bloat. Today it hasn''t been able to get over 32,000KB
without corrupting. We are constantly getting messages of
"unrecognizeable database format". Does anyone have any insight? I
can''t continue like this - it is a production support database. When
it is down we lose valuable time and money.

Thanks!

Pamela DeVries

特里，


感谢您的建议。现在我的部门（访问开发服务）和网络团队之间一直在争夺战。他们

坚持认为网络没有任何问题。但我把这个

数据库分开并重新组合在一起 - 试图找到各种方式

可以简化它，我们仍然有这样的问题

为磁盘或网络错误消息一直都是。到目前为止我的策略

只是记录实例和我们遇到的问题

必须给他们提供确凿的证据。但他们只是坚持认为它不是网络问题 - 这不是网络问题等等......唉！我做了

有用户最近升级到Win2K（很多人在这家公司

仍在运行Win95 !!!!）以努力提高

客户端和服务器进行通信。对于任何人来说，似乎没有做过任何事情。


Pamela DeVries


"问题无法在创造

的意识水平上解决。

- 阿尔伯特爱因斯坦

***通过Developersdex发送< a rel =nofollowhref =http://www.developersdex.comtarget =_ blank> http://www.developersdex.com ***

Don 只是参加USENET ......获得奖励！

Terry,

Thanks for the suggestion. There is a constant battle right now between
my department (Access Development Services) and the network team. They
insist nothing is wrong with the network. But I have taken this
database apart and put it back together again - trying to find every way
possible to streamline it and we still have problems like this as well
as "Disk or network error" messages all the time. My strategy thus far
has been to just keep a log of the instances and the problems we have
been having to give them hard evidence. But they just insist that it''s
not a network problem - it''s not a network problem, etc... UGH! I did
have the power users recently upgraded to Win2K (many in this company
still running Win95!!!!) in an effort to increase the speed at which the
client and the server communicate. That doesn''t seem to have done
anything for anyone.

Pamela DeVries

"Problems cannot be solved at the same level of awareness that created
them."
--Albert Einstein
*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

Pamela，

这可能不是问题，但是既然你提到你的

网络混合了Win9x和NT类机器，后端

是否存在于Win2Ks访问的Win9x机器上？如果是这样的话，那么你需要将
的份额转移到其中一台Win2K机器上，因为这可能会导致腐败。


大部分可能是一个片状网络。


此外，请参阅......
http://support.microsoft.com/default...b;EN-US;303519


- Jim


2003年10月15日16:41:47 GMT，Pamela DeVries< pd ****** @ steelcase.com>

写道：

Pamela,
This is probably not the problem, but since you mention that your
network has a mix of Win9x and NT class machine, does the backend
reside on a Win9x machine accessed by the Win2Ks? If so then you
should move the share to one of the Win2K machines as that can
contribute to corruption.

Most likely a flaky network.

Also, see ...
http://support.microsoft.com/default...b;EN-US;303519

- Jim

On 15 Oct 2003 16:41:47 GMT, Pamela DeVries <pd******@steelcase.com>
wrote:

特里，

感谢您的建议。现在，我的部门（Access Development Services）和网络团队之间一直在争夺战。他们坚持认为网络没有任何问题。但是我把这个
数据库分开并重新组合在一起 - 试图找到各种方式
可以简化它，我们仍然有像这样的问题
作为磁盘或网络错误"消息一直都是。到目前为止，我的策略是只记录实例和我们遇到的问题，而不得不给他们提供确凿的证据。但他们只是坚持认为它不是网络问题 - 它不是网络问题等等......唉！我确实让最近升级到Win2K的高级用户（许多人在这家公司中仍然运行Win95 !!!!）以努力提高客户端和服务器通信的速度。对于任何人来说似乎都没有做过任何事情。

Pamela DeVries

问题无法在创造的意识水平上解决< br / >them."
- 阿尔伯特爱因斯坦

***通过Developersdex发送 http://www.developersdex.com ***
不要只是参加USENET ......获得奖励！

Terry,

Thanks for the suggestion. There is a constant battle right now between
my department (Access Development Services) and the network team. They
insist nothing is wrong with the network. But I have taken this
database apart and put it back together again - trying to find every way
possible to streamline it and we still have problems like this as well
as "Disk or network error" messages all the time. My strategy thus far
has been to just keep a log of the instances and the problems we have
been having to give them hard evidence. But they just insist that it''s
not a network problem - it''s not a network problem, etc... UGH! I did
have the power users recently upgraded to Win2K (many in this company
still running Win95!!!!) in an effort to increase the speed at which the
client and the server communicate. That doesn''t seem to have done
anything for anyone.

Pamela DeVries

"Problems cannot be solved at the same level of awareness that created
them."
--Albert Einstein
*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

这篇关于救命！为什么我的数据库会不断破坏？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！