Hi all, W2000 Server, SP2, MS SQL 2000, TDP SQL 2.2 Sometimes (3-4 days in week) TDP client failed to connect to SQL server at start of backup and full backup failed. This is part of sqlsched.log: ======================= 04/01/2002 03:00:04 Executing scheduled command now. 04/01/2002 03:00:04 Executing Operating System command or script: "c:\program files\tivoli\tsm\tdpsql\sqlfull.cmd" The current date is: po 01.04.2002 Enter the new date: (dd-mm-yy) The current time is: 3:00:04,92 Enter the new time: 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\sqlfull.log log file was pruned successfully. ACO5424E Could not connect to SQL server; SQL server returned: [Microsoft][ODBC SQL Server Driver]Timeout expired Microsoft SQL-DMO (ODBC SQLState: HYT00) (HRESULT:0x80040000) 04/01/2002 03:04:22 Finished command. Return code is: 1900 04/01/2002 03:04:22 ANS1512E Scheduled event 'SQL_FULL' failed. Return code = 1900. ======================== SQL server is surely running at this time. At other days all works good: ======================== 04/02/2002 03:00:03 Executing scheduled command now. 04/02/2002 03:00:03 Executing Operating System command or script: "c:\program files\tivoli\tsm\tdpsql\sqlfull.cmd" The current date is: -t 02.04.2002 Enter the new date: (dd-mm-yy) The current time is: 3:00:03,13 Enter the new time: 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\sqlfull.log log file was pruned successfully. Starting SQL database backup... Beginning full backup for database master, 1 of 7. Full: 0 Read: 6656 Written: 0 Rate: 0.00 Kb/Sec Full: 3 Read: 6291456 Written: 3145728 Rate: 1,167.62 Kb/Sec Full: 3 Read: 10485760 Written: 7340032 Rate: 1,971.40 Kb/Sec Full: 0 Read: 11357696 Written: 11357696 Rate: 2,233.94 Kb/Sec Full: 0 Read: 11358992 Written: 11358992 Rate: 1,859.64 Kb/Sec Full: 0 Read: 11358992 Written: 11358992 Rate: 1,592.64 Kb/Sec Full: 0 Read: 11358992 Written: 11358992 Rate: 1,392.69 Kb/Sec Full: 0 Read: 11358992 Written: 11358992 Rate: 1,392.69 Kb/Sec Backup of master completed successfully. Beginning full backup for database model, 2 of 7. Full: 0 Read: 870160 Written: 870160 Rate: 852.32 Kb/Sec Full: 0 Read: 870160 Written: 870160 Rate: 567.65 Kb/Sec Backup of model completed successfully. ...... an so on Any ideas? Any solution? Why connecting to SQL server failed sometimes? Wiht best regards Tom
