ADSM-L

Re: [ADSM-L] TSM open file option question

2008-10-08 07:34:13
Subject: Re: [ADSM-L] TSM open file option question
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 8 Oct 2008 07:32:15 -0400
On Oct 8, 2008, at 12:22 AM, Wira Chinwong wrote:

TSMMers,
        Without TDP for database or mail, can I use TSM client backup the
SQLServer,Exchange or Domino with "open file agent option"? It works
in my
test environment but there is no workload on the system. Anybody who
have an
experience please suggest.


As we always advise:
Backing up a database or similar server in a detached, file-oriented
manner while that facility is running is a bad idea, in that parts of
the database are either in flight or in server memory.  Further, the
stepwise backup of component files inevitably results in inter-file
inconsistency.  While the backup may run fine, the probability is high
that attempted restoral would result in incoherency, where the server
may fail to run with such data or data may be lost or corrupted.  The
TSM TDPs operate with APIs provided by the vendors of such database
server products so that the backup can work in concert with the active
server's operations in order to produce a restorable whole.

   Richard Sims