Hi folks.
I am very new to TSM, so please bare over with me if I ask in a stupid way
I'm having problems with one client.
In the weekend and now and then 1 database out of 7 wount backup.
Does anyone have an idea what could couse this from these error logs? :
sqlfull
09/12/2011 19:22:34 Backup of SQL Database backup1 will not be attempted.
09/12/2011 19:22:34 ACO5422E Received the following from the MS SQL server:
09/12/2011 19:22:34 An exception occurred while executing a Transact-SQL statement or batch.
09/12/2011 19:22:34 Database 'backup1' cannot be opened. It is in the middle of a restore. (HRESULT:0x80131501)
09/12/2011 20:14:12 ACO5436E A failure occurred on stripe number (0), rc = 418
09/12/2011 20:14:12 ANS1017E (RC-50) Session rejected: TCP/IP connection failure
09/12/2011 20:14:12 Backup of NAV01 failed.
09/12/2011 20:14:12 ANS1017E (RC-50) Session rejected: TCP/IP connection failure
09/12/2011 20:15:23 Total SQL backups selected: 11
09/12/2011 20:15:23 Total SQL backups attempted: 7
09/12/2011 20:15:23 Total SQL backups completed: 6
09/12/2011 20:15:23 Total SQL backups excluded: 3
09/12/2011 20:15:23 Total SQL backups inactivated: 0
09/12/2011 20:15:23 Throughput rate: 675.72 Kb/Sec
09/12/2011 20:15:23 Total bytes transferred: 2,177,683,968
09/12/2011 20:15:23 Elapsed processing time: 3,147.23 Secs
09/12/2011 20:15:23 ACO0151E Errors occurred while processing the request.
09/12/2011 20:15:23 ACO0151E Errors occurred while processing the request.
dsierror
09/12/2011 20:15:23 ANS1909E The scheduled command failed.
09/12/2011 20:15:23 ANS1512E Scheduled event 'HVERDAG_MIDNAT_FULL_SQL' failed. Return code = 402.
schedlog
09/12/2011 19:22:32
Executing Operating System command or script:
C:\SQLFULL.CMD
09/12/2011 20:15:23 Finished command. Return code is: 402
09/12/2011 20:15:23 ANS1909E The scheduled command failed.
09/12/2011 20:15:23 ANS1512E Scheduled event 'HVERDAG_MIDNAT_FULL_SQL' failed. Return code = 402.
09/12/2011 20:15:23 Sending results for scheduled event 'HVERDAG_MIDNAT_FULL_SQL'.
09/12/2011 20:15:44 Session established with server TSM-04: Windows
09/12/2011 20:15:44 Server Version 6, Release 1, Level 2.0
09/12/2011 20:15:44 Server date/time: 09/12/2011 20:15:29 Last access: 09/12/2011 20:14:15
From Windows Event Log
Windowsevetlog error at 12-09-2011 20:14:12
Event 1, SQLVDI
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=4028. Thread=3288. Client. Instance=. VD=Global\TDPSQL-00000FBC-0000_SQLVDIMemoryName_0.
Event 18210, MSSQLSERVER
BackupIoRequest::ReportIoError: write failure on backup device 'TDPSQL-00000FBC-0000'. Operating system error 1003(failed to retrieve text for this error. Reason: 15105).
I am very new to TSM, so please bare over with me if I ask in a stupid way
I'm having problems with one client.
In the weekend and now and then 1 database out of 7 wount backup.
Does anyone have an idea what could couse this from these error logs? :
sqlfull
09/12/2011 19:22:34 Backup of SQL Database backup1 will not be attempted.
09/12/2011 19:22:34 ACO5422E Received the following from the MS SQL server:
09/12/2011 19:22:34 An exception occurred while executing a Transact-SQL statement or batch.
09/12/2011 19:22:34 Database 'backup1' cannot be opened. It is in the middle of a restore. (HRESULT:0x80131501)
09/12/2011 20:14:12 ACO5436E A failure occurred on stripe number (0), rc = 418
09/12/2011 20:14:12 ANS1017E (RC-50) Session rejected: TCP/IP connection failure
09/12/2011 20:14:12 Backup of NAV01 failed.
09/12/2011 20:14:12 ANS1017E (RC-50) Session rejected: TCP/IP connection failure
09/12/2011 20:15:23 Total SQL backups selected: 11
09/12/2011 20:15:23 Total SQL backups attempted: 7
09/12/2011 20:15:23 Total SQL backups completed: 6
09/12/2011 20:15:23 Total SQL backups excluded: 3
09/12/2011 20:15:23 Total SQL backups inactivated: 0
09/12/2011 20:15:23 Throughput rate: 675.72 Kb/Sec
09/12/2011 20:15:23 Total bytes transferred: 2,177,683,968
09/12/2011 20:15:23 Elapsed processing time: 3,147.23 Secs
09/12/2011 20:15:23 ACO0151E Errors occurred while processing the request.
09/12/2011 20:15:23 ACO0151E Errors occurred while processing the request.
dsierror
09/12/2011 20:15:23 ANS1909E The scheduled command failed.
09/12/2011 20:15:23 ANS1512E Scheduled event 'HVERDAG_MIDNAT_FULL_SQL' failed. Return code = 402.
schedlog
09/12/2011 19:22:32
Executing Operating System command or script:
C:\SQLFULL.CMD
09/12/2011 20:15:23 Finished command. Return code is: 402
09/12/2011 20:15:23 ANS1909E The scheduled command failed.
09/12/2011 20:15:23 ANS1512E Scheduled event 'HVERDAG_MIDNAT_FULL_SQL' failed. Return code = 402.
09/12/2011 20:15:23 Sending results for scheduled event 'HVERDAG_MIDNAT_FULL_SQL'.
09/12/2011 20:15:44 Session established with server TSM-04: Windows
09/12/2011 20:15:44 Server Version 6, Release 1, Level 2.0
09/12/2011 20:15:44 Server date/time: 09/12/2011 20:15:29 Last access: 09/12/2011 20:14:15
From Windows Event Log
Windowsevetlog error at 12-09-2011 20:14:12
Event 1, SQLVDI
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=4028. Thread=3288. Client. Instance=. VD=Global\TDPSQL-00000FBC-0000_SQLVDIMemoryName_0.
Event 18210, MSSQLSERVER
BackupIoRequest::ReportIoError: write failure on backup device 'TDPSQL-00000FBC-0000'. Operating system error 1003(failed to retrieve text for this error. Reason: 15105).