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
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 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 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.
==============================================================================
