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