We backup SQL with TSM and use 2 different methods. One is the TSM SQL backup (yes we had to purchase an extra license for this) the other on our banking system we backup the database to a file and then just use TSM to backup the file. we use a job server that does the backups to file, the backup to TSM (command line) then a delete of the file when it is completed.
Tammy Schellenberg Systems Administrator, MCP Prospera Credit Union email: [EMAIL PROTECTED] DID: 604-864-6578 -----Original Message----- From: Curtis Stewart [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 9:01 AM To: [EMAIL PROTECTED] Subject: Re: TSM & SQL databases 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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 11/18/2004 10:54 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] 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 [EMAIL PROTECTED] (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. This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you receive this email in error, please immediately notify the sender. Please note that this financial institution neither accepts nor discloses confidential member account information via email. This includes password related inquiries, financial transaction instructions and address changes.
