ADSM-L

TSM & SQL databases

2004-11-18 11:56:13
Subject: TSM & SQL databases
From: Ruth Peters <Ruth.Peters AT WATKINS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 18 Nov 2004 11:54:00 -0500
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>