Our TDP for MSSQL backup is failing.. this is a newly installed
clustered win2k server.. I'm not sure whats happening here. I see the
one error below in sqlsched.log but would that cause it to hang? It
seems to hang and not complete it's backup. At 7:30 it giving up and
marks it as failed. Would adding an exclude for "tempdb" solve this
perhaps? The one thing confusing is we're not doing a logfile backup. We
do a weekly full and daily differential. These examples/output are from
the daily differential attempt. I'm looking for opinions here if anyone
has any things to try. Thanks!

The msg in dsmsched.log is as follows:

12/21/2001 07:37:56
Executing scheduled command now.
12/21/2001 07:37:56 Node Name: UDDIDB-MSSQL
12/21/2001 07:37:57 Session established with server UTSLC01: AIX-RS/6000
12/21/2001 07:37:57   Server Version 3, Release 7, Level 5.0
12/21/2001 07:37:57   Server date/time: 12/20/2001 23:45:50  Last
access: 12/20/2001 23:33:27

12/21/2001 07:37:57 ANS1814E Unable to start scheduled event
'HPUDDI-SQLDIFF'
12/21/2001 07:37:57 ANS1815E Either the window has elapsed or the
schedule has been deleted
12/21/2001 07:37:57 Querying server for next scheduled event.

The msg in dsmerror.log is as follows:

12/21/2001 07:37:57 ANS1814E Unable to start scheduled event
'HPUDDI-SQLDIFF'
12/21/2001 07:37:57 ANS1815E Either the window has elapsed or the
schedule has been deleted

The msg In sqlsched.log is as follows:

Tivoli Storage Manager
Tivoli Data Protection for Microsoft SQL Server
Version 2, Release 2, Level 0.0
(C) Copyright IBM Corporation 1997, 2001. All rights reserved.

ACO5057I The C:\Progra~1\Tivoli\TSM\TDPSql\sqldiff.log log file was
pruned successfully.

ACO5422E Received the following from the MS SQL server:
[Microsoft][ODBC SQL Server Driver][SQL Server]The log for database
'tempdb' is not available. Microsoft SQL-DMO (ODBC SQLState: HY000)
(HRESULT:0x80042329)




Gerald Wichmann
System Engineer
StorageLink
408-844-8893 (v)
408-844-9801 (f)