For TDP for SQL 2.2 you would specify TDPSQLC BACKUP * FULL plus whatever
options you need. This will backup all databases but not tempdb, tempdb is
always excluded from all TDP for SQL operations. The wild card can be
partial, such as abc* and databases can be excluded from backup using
exclude statements in the dsm.opt file.
TDP for SQL 2.2 uses TSM policy management so you don't have to use
autodelete. The policy management settings can control how many versions to
keep and for how long.
For more details you can get the TDP for SQL 2.2 manual at
http://www.tivoli.com/support/public/Prodman/public_manuals/storage_mgr/v1_html/mssql/v2/ab5mtfrm.htm
Bob King
bobking AT us.ibm DOT com
David Longo <David.Longo AT HEALTH-FIRST DOT ORG>@VM.MARIST.EDU> on 05/10/2001
04:50:13 PM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Re: TDP for SQL Question
Yes, by default that is the way it is done. After you install TDP on the
client, look in the ..Tivoli/TSM/Mssql directory. The file sqlfull.smp is
designed to be copied to sqlfull.cmd. You need to edit the bat file for
directories etc. The backup command in it wil do a full backup of ALL
DB's, even tempdb even thought this is not valid for restore.
Note also last line in file for doing autodelete of backups, you can
specify how many copies you want to keep.
This info is valid for TDP MSSQL 1.1.2, I use here on about a dozen NT 4.0
machines with SQL 6.5, 7.0 and 2000. 1.1.1 does not have autodelete, may
be similar info for ver 2.2.
David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH 321.434.5536
Pager 321.634.8230
Fax: 321.434.5525
david.longo AT health-first DOT org
>>> curtis.magura AT LMCO DOT COM 05/10/01 04:29PM >>>
We are looking into starting to use TDP for SQL. Question from our DBA's:
When configuring the SQL Server backups is it possible to configure a
backup
that will backup ALL the SQL Server databases (master, msdb, and user
created) with one command such that if additional databases are added to
SQL
Server they are automatically backed up? OR does TDP have to be configured
every time a new database is added in SQL Server?
Curt Magura
Lockheed Martin EIS
Gaithersburg, Md.
301-240-6305
"MMS <health-first.org>" made the following
annotations on 05/10/01 16:51:55
------------------------------------------------------------------------------
This message is for the named person's use only. It may contain
This message is for the named person's use only. It may contain
confidential, proprietary, or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it, and notify
the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient. Health First reserves the right to monitor all e-mail
communications through its networks. Any views or opinions expressed in
this message are solely those of the individual sender, except (1) where
the message states such views or opinions are on behalf of a particular
entity; and (2) the sender is authorized by the entity to give such views
or opinions.
=============================================================================
|
