We are thinking about reviewing all of our SQL clients and setting up
maintenance schedules for those that are applicable (regardless if SQL 2000
or 2005). We have been asked to back up SQL in some cases, and in some cases,
apps are completely vendor supported. Therefore, where applicable, we plan on
setting up maintenance plans and backing up the flat files with the base
client. That will eliminate the need for TDP on those machines, and most
importantly, we will reclaim those licenses.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Thomas Rupp
Sent: Tuesday, July 03, 2007 10:23 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Manage backup of MS SQL 2005 server with TDP from SQL

Hi TSM-ers,

I have to backup our MS SQL 2005 server with TDP and was asked how TDP
can be integrated in the MS SQL Maintenance Plans.

Our SAP backups are scheduled by SAP
Our Oracle backups are scheduled by OEM
Our SQL backups should be scheduled by the MS SQL Management Studio

I'm no MS SQL guy so I would like to hear how you schedule your SQL
backups.

Thanks in advance
Thomas Rupp



Vorarlberger Illwerke AG ein Unternehmen von illwerke vkw
Rechtsform: Aktiengesellschaft, Sitz: Bregenz, Firmenbuchnummer: FN 59202 m,
Firmenbuchgericht: LG Feldkirch, UID-Nr.: ATU 36737402

-----------------------------------------
Confidentiality Notice:
The information contained in this email message is privileged and
confidential information and intended only for the use of the
individual or entity named in the address. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this information is strictly
prohibited. If you received this information in error, please
notify the sender and delete this information from your computer
and retain no copies of any of this information.