Phil,

If you get the latest PTF (1.1.2) of TDP for SQL,
it automatically excludes tempdb for SQL 7.0 backups.

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com


Phil Bone <PBone AT AFLAC DOT COM>@VM.MARIST.EDU> on 02/03/2000 11:36:17 AM

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:  Excluding temdb using Connect Agent for MS-SQL?



Is there a way to exclude the tempdb when using the ADSM Connect Agent to
backup up SQL Server?  The current job our DBA has setup backups all the
databases but he gets a return code of failure because the tempdb cannot be
backed up.  The documentation says to do something like:

sqldsmc /backupfull:a*
sqldsmc /backupfull:b*
.
.
.
sqldsmc /backupfull:(database name that starts with t)
ect.
ect.

The other option would be to specify each database name individually, but
then you run the risk of "forgetting" to add new databases to the list.

This is a bit unmanageable.

Thanks in advance.


Phil Bone
Sr. Systems Consultant
Network Services, Infrastructure Management
Office: 706.596.5928
Fax: 706.596.5950
Email: pbone AT aflac DOT com
Email: philbone AT mindspring DOT com