Re: Crashes every 5 days at 11AM

On Tue, 25 Mar 2008 11:08:34 -0700 (PDT), NScheffey
<NScheffey@xxxxxxxxx> wrote:

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

Are you using third-party software for scheduled backup[s]? Or are
you doing scheduled backup[s] from within FileMaker Server? Or
possibly both?

The fact that the db always reopens suggests to me that you're having
an issue with locked files, i.e. files in use by another process. If
you're using third-party software for backup, or even if you're just
using Scheduled Tasks and xcopy, make sure it's not trying to backup
at simultaneously with FileMaker. Also, make sure you're not trying
to do several different backups to the same path. Spread your backups
around. Each scheduled backup really should have its own path.

What I like to do is, I let FM Server do scheduled backups. Then I
use a third-party backup utility to backup the backups by copying them
to various places on the network. This eliminates the possibility of
trying to backup a file that's locked. And it's all scheduled and
completely automated.

Last thing I would suggest is, try doing a restore from one of your
backups. No backup protocol can be considered reliable if it hasn't
been tested by restoring the backed-up data.

hope this helps

--
FW

FileMaker Pro 8.5 on Windows XP Pro SP2
FileMaker Server 8.0 on Windows 2003 Server
.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Copying a database between servers
    ... In 2000 you can backup to an UNC path ... or a local drive and the same goes for the restore. ... backup the database and then restore it on the new server. ... >>> one SQL Server 7.0 database with 'select' access to another SQL ...
    (microsoft.public.sqlserver.tools)
  • RE: Adventures in Server restore
    ... SP1 for exchange change the db jet and should fix this problem ... > I thought I'd pass on my experience in bringing back an exchange server ... I'm not sure what happened (but a online backup was going on) ... > persists then please restore the database from a previous backup. ...
    (microsoft.public.exchange.admin)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)