Robert, this is a SQL Server restriction. In the SQL Server Books Online
section "Backing Up the master Database" there is "Note Only full database
backups of master can be created".

To use the command "tdpsqlc backup * log" you can enter an exclude
statement in the TSM options file (default "dsm.opt"):
   exclude "\...\master\...\log*"
See Appendix B in the TDP for SQL User's Guide.

Any database that has the "Truncate Log On Checkpoint" option will have the
same problem: its transaction log cannot be backed up.

Bob King    IBM Global Services
bobking AT us.ibm DOT com


Robert Ouzen <robert AT RESEARCH.HAIFA.AC DOT IL>@VM.MARIST.EDU> on 03/06/2001
09:47:38 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:  Sql Backup Error

Hi

I made a full backup of my SQL database with my TDP for Ms Sql Sever
version 2.2.0.0 successfully.
When I tried to run the LOGS backup I received for the MASTER an error
message:

ACO5422E Received the following from the MS SQL server:
03/06/2001 16:34:42 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
back up the log of the master database. Use BACKUP DATABASE instead.

All other databases (cetsgrp, model , msdb , northwind, pubs) finished
succesfully .......

Any Ideas why Master failed !!!!!!

T.I.A Robert Ouzen

robert AT research.haifa.ac DOT il