From: Joe Haynes (jhayneskeycomputerconsultants.com)
Date: Fri Dec 16 2005 - 13:02:50 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Kevin,

This is not really a good idea with a database that is
currently running. The backup software will only be able
to capture each file a few chunks at a time so the file
you start to backup won't really be the same by the time
you finish (i.e. it's a moving target as you are backing it up).

My guess is that your are going to run into lots of
integrity issues when you restore and attempt to
restart the db.

Thanks,

Joe Haynes
Helena, MT
Terra Firma Software Solutions, Inc.

On Fri, 2005-12-16 at 12:44 -0600, Kevin Wilson wrote:
> If our backup software has open file support then would it be able to backup
> any file that is open and in use?
>
> Backup sw = ArcServe (Windows)
> db system = MaxDB x64 on SuSE Linux x64
>
> -----Original Message-----
> From: "Döhr, Markus ICC-H" [mailto:Markus.Doehrsiegenia-aubi.com]
> Sent: Friday, December 16, 2005 12:41
> To: Kevin Wilson; Maxdb (E-mail)
> Subject: RE: backup of installation and data directories
>
>
> > I want to have our tape backup system come in and copy to
> > tape the full directory tree(s) of where maxdb is installed
> > while the database is running in online mode. Is there any
> > reason I cannot do this?
>
> No but you will not be able to backup the data files since they are open and
> used by the database.
>
>
> Greetz,
>
>
> SIEGENIA-AUBI KG
> Informationswesen
>
> i.A.
>
> Markus Döhr
> SAP-CC/BC, SAPDB-DBA
>
> Tel.: +49 6503 917-152
> Fax: +49 6503 917-7152
> E-Mail: markus.doehrsiegenia-aubi.com
> Internet: http://www.siegenia-aubi.com
>
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]