ADSM-L

Re: TSM & SQL databases

2004-11-18 12:01:17
Subject: Re: TSM & SQL databases
From: Curtis Stewart <Curtis.Stewart AT LAWSON DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 18 Nov 2004 11:00:33 -0600
If you need the file deleted after it's sent to TSM, look at TSM's archive
function and its various options.

Curtis





Ruth Peters <Ruth.Peters AT WATKINS DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
11/18/2004 10:54 AM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
TSM & SQL databases






I have a windows 2000 server with a SQL database. The database is backed
up
using SQL's enterprise utility. Once the SQL backup is complete there is a
need
to delete this backup file  from the server to ensure there is adequate
database space prior to the next scheduled database backup. I'm currently
using a
different backup product that actually backs up the file and then deletes
the
file from the server.

We are looking at moving this server to TSM, however from what I can see
TSM
does not do any type of file deletion from the client. The other option
would
be to
use TDP for SQL to manage the database backups, however there is
additional
cost with that. Is there anyone using TSM to backup SQL databases and if
so how do you delete the files from the client once they are backed up??

TSM SERVER
AIX 5.2.3
TSM Version 5.2.3

WINDOWS 2000 SERVER
TSM 5.2.0.1
Service Pack Level 4.0
SQL Server 2000 Standard edition
Service Pack 3 for SQL



Ruth Peters
Dasd Storage Administrator
Watkins Motor Lines, Inc. - IT/HDQ
Ruth.Peters AT Watkins DOT Com
(863)688.6662 x5452


******************NOTICE*******************
This e-mail, including any attachments, is intended for the receipt and
use by the intended addressee(s) only and may contain privileged,
confidential, work-product and/or trade secret information of a
proprietary nature.  If you are not an intended recipient of this e-mail,
you are hereby notified that any unauthorized use, distribution or
re-transmission of this e-mail or any attachment(s) is strictly prohibited
and that all rights of the sender and/or intended recipients are hereby
reserved without prejudice thereto.

<Prev in Thread] Current Thread [Next in Thread>