From owner-freebsd-questions Fri Apr 23 13:47:49 1999 Delivered-To: freebsd-questions@freebsd.org Received: from coffee.veryfast.net (coffee.veryfast.net [216.89.192.10]) by hub.freebsd.org (Postfix) with ESMTP id E272E1550C for ; Fri, 23 Apr 1999 13:47:47 -0700 (PDT) (envelope-from jpm@igcinc.com) Received: from jpm (dhcp3.internal.igcinc.com [10.10.10.152]) by coffee.veryfast.net (8.9.1/8.9.1) with SMTP id PAA04533; Fri, 23 Apr 1999 15:42:55 -0500 (CDT) Message-Id: <199904232042.PAA04533@coffee.veryfast.net> From: "John McNamee" Organization: IGC To: Doug White Date: Fri, 23 Apr 1999 15:46:18 -0600 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: Tape Backup Cc: freebsd-questions@freebsd.org References: <4.1.19990422150523.017f6660@mail.pcinternet.net> In-reply-to: Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On 23 Apr 99 at 13:22, Doug White wrote: > > Is there tape backup software for FreeBSD that in addition to backing up UNIX > > will also backup NT Servers with Registry and Microsoft SQL Server on a live > > system. I am using BE for NT currently but would like to move yet another > > network function to BSD. > > Backing up SQL databases requires the backup program to have initmate > knowledge of the DB system so it can handle the hot backup properly. > I doubt it can be done from remote reliably. FYI... The way this is handled in the NT and Netware worlds is that the backup software doesn't directly access the SQL database files. An agent (e.g. daemon) runs on the database server machine, and it handles all the details of database I/O to allow hot backup and restore. These agents are all proprietary -- you need one specific both to the database and the backup product. Database agents are typically a high priced add-on and not part of the basic backup software. --John To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message