The ANS1815E means what it says. Check the time you have set up for the scheule to run and what time it actually starts. Also what is the "duration" you have set for the schedule, is it long enough? Is there another schedule runnin on this clinet prior to this one? Maybe it is taking too long and when this one tries to start, it is past it's time and duration.
I haven't done Log backups yet but tempdb backup is not vailed/useless. You may be able to ignorwe any error messages for it, unless it is hanging up rest of backup. I would have to look but I think there is a way to take tempdb out of loop from backups, partially depends on version of MSSQL and TDP agent. David Longo >>> [EMAIL PROTECTED] 12/21/01 03:00PM >>> 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) "MMS <health-first.org>" made the following annotations on 12/21/01 16:27:51 ------------------------------------------------------------------------------ This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ==============================================================================
