Crashes every 5 days at 11AM
Hello all-
I'm experiencing a strange recurring problem. I am serving a 250MB
FMS9 database (running on Windows 2003 Small Business) to 6 FMP9
clients. Every five days, the database will crash ("Database is
damaged and has been closed") at 11:00AM - 11:05AM. It will do this
for two consecutive days. Then for five days it will be fine. The
database always reopens.
Server logs show that this is happening during the scheduled half-hour
backups. But it is only happening during the 11AM backup, and only two
days out of the week. I've tried compacting the file, but that didn't
change anything. I've also made sure there isn't any anti-virus
software accessing the database files.
Any thoughts?
Nate
.
Relevant Pages
- Re: Database Size, Database Corruption, Message Store & Storage Group
... More careful monitoring of the server. ... Each extra storage group also requires more memory at startup, ... Also it is important to know if there was actually database corruption. ... In terms of backups, you should look at "how" you are performing backups. ...
(microsoft.public.exchange.admin) - Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
... so we need frequent copies of the database for testing, ... Andrew J. Kelly SQL MVP ... But by placing the backups on the same drive as the data or logs you risk loosing data if one of the drives crashes since you will loose backups and either the log or data files. ...
(microsoft.public.sqlserver.programming) - RE: Log Shipping and Full Backup Frequency. Advice?
... The transaction log is different; it is a recording of database actions. ... And, if you restore from any of these, you only get that state. ... This is not the case with the transaction log or its backups. ...
(microsoft.public.sqlserver.server) - Re: Pervasive SQL 8.6
... and backups are done by copying the files off to tape - ... you'll want to have lots of memory on the server -- ... drives for the database files. ... set up your SAN with a configuration of 80% memory set ...
(comp.databases.btrieve) - Re: Maintenance Recomendations -Compact?
... recs" you actually mean Maintenance Requirements, ... your database is still monolithic; ... That frequent Compact and Repair ... So, in addition to the above, take frequent backups of your ...
(microsoft.public.access.gettingstarted) |
|
