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
[EMAIL PROTECTED]
Robert Ouzen <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 03/06/2001
09:47:38 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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
[EMAIL PROTECTED]
