From owner-freebsd-questions@FreeBSD.ORG Fri Apr 1 15:44:34 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id CB83416A4CE for ; Fri, 1 Apr 2005 15:44:34 +0000 (GMT) Received: from prosporo.hedron.org (hedron.org [66.11.182.60]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3EBC643D31 for ; Fri, 1 Apr 2005 15:44:34 +0000 (GMT) (envelope-from ean@hedron.org) Received: from www.hedron.org (localhost.hedron.org [127.0.0.1]) by prosporo.hedron.org (Postfix) with ESMTP id 4769FC11D for ; Fri, 1 Apr 2005 10:45:14 -0500 (EST) Received: from 216.220.59.169 (SquirrelMail authenticated user ean); by www.hedron.org with HTTP; Fri, 1 Apr 2005 10:45:14 -0500 (EST) Message-ID: <3639.216.220.59.169.1112370314.squirrel@216.220.59.169> In-Reply-To: <424CA2B9.1030304@netfence.it> References: <424AACD1.3060802@netfence.it> <20050330134259.GA66640@xor.obsecurity.org> <424AE8FA.8080306@netfence.it> <20050331125337.M34511@zoraida.natserv.net> <424CA2B9.1030304@netfence.it> Date: Fri, 1 Apr 2005 10:45:14 -0500 (EST) From: "Ean Kingston" To: freebsd-questions@freebsd.org User-Agent: SquirrelMail/1.4.3a X-Mailer: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal Subject: Re: mksnap_ffs woes X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 01 Apr 2005 15:44:34 -0000 > Francisco Reyes wrote: > >> In my experience databases DO NOT like file system backups unless the >> database is NOT running. The more heavily you use the database the least >> it will play nice with file system backups. > > Unfortunately we have no choice. Sorry if this has been mentioned before but have you considered a split-mirror-backup? It would involve some downtime but only a few minutes for each backup. It would be cheaper than replacing all the clients. >> Is using the database backup routines an option? > > Nope. > >> Does the database has any type of replication? > > Nope again. > >>> BTW, we have almost no room for changes on the client side :( >> >> What is the client side? > > Some *old* PCs (need ISA slots) running an old DOS [wannabe] application > (actually a plethora of .BAT files and some .EXEs) on Windows 95 or 98 :( > Not even the firm who made that crap is willing to put their hands on it. > Replacing the software would mean replacing the hardware (not only the > PCs, but the attached machines too) at multiple sites, which would mean > a HUGE amount of money; that's behind my power and is to be considered > out of question. > >> Given that you said it is in Samba is seems it's some type of windowd >> database. Is it a workgroup type of DB like Access or Foxpro? SQL >> server? > > It's some bunch of DBFs with associated indexes and God only knows what > else. Given the clients need to be up 24/7, I though of filesystem > snapshots as the only solution. > > I'll keep trying a bit more, since it seems doing them on a daily > schedule doesn't do any harm. The problems so far have only arisen when > I manually started a backup script (possibly interrupting it, cleaning > up, and starting again). > > bye & Thanks > av. > > P.S. The firm who sold that crap, also implemented the file server > before mine; just without any RAID and/or backup facility. These data > are vital to that business. -- Ean Kingston E-Mail: ean_AT_hedron_DOT_org PGP KeyID: 1024D/CBC5D6BB URL: http://www.hedron.org/