From owner-freebsd-questions@FreeBSD.ORG Thu Mar 31 17:53:37 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 C159316A4CE for ; Thu, 31 Mar 2005 17:53:37 +0000 (GMT) Received: from mail1.acecape.com (mail1.acecape.com [66.114.74.12]) by mx1.FreeBSD.org (Postfix) with ESMTP id 602A443D53 for ; Thu, 31 Mar 2005 17:53:37 +0000 (GMT) (envelope-from lists@natserv.com) Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147]) by mail1.acecape.com (8.12.11/8.12.11) with ESMTP id j2VHrZx8025887; Thu, 31 Mar 2005 12:53:36 -0500 Date: Thu, 31 Mar 2005 12:56:53 -0500 (EST) From: Francisco Reyes X-X-Sender: fran@zoraida.natserv.net To: Andrea Venturoli In-Reply-To: <424AE8FA.8080306@netfence.it> Message-ID: <20050331125337.M34511@zoraida.natserv.net> References: <424AACD1.3060802@netfence.it> <20050330134259.GA66640@xor.obsecurity.org> <20050330141626.GB73682@xor.obsecurity.org> <424AE8FA.8080306@netfence.it> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed cc: freebsd-questions@freebsd.org cc: Kris Kennaway 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: Thu, 31 Mar 2005 17:53:37 -0000 On Wed, 30 Mar 2005, Andrea Venturoli wrote: > I'll explain my needs briefly: I export (via Samba) a whole bunch of > databases that 9 clients read and write. What databases? > a) backup data so that in case of severe failure we can get it rapidly back > (we are going to loose the last transactions, obviously); 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. Is using the database backup routines an option? Does the database has any type of replication? > We probably can live with some incoherent records in a) Depending on the database system you are using the copies may be totally useless if you do a filesystem backup/sync. > BTW, we have almost no room for changes on the client side :( What is the client side? 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? -- http://stringsutils.com Utility for developers. Compute length, MD5, CRC and more.