My apologies to begin with, I am the neither the SQL Admin nor the TSM
Admin. I am but the Systems administrator, trying to together to piece
together the failure.
Problem: TDP backups of (2) SQL 2000 instances running on a single server
are failing. Any help determining the cause of this would be greatly
appreciated. This is a production server (problem found after production
switch) so no backups is very scary.
Specs:
OS: Windows 2003 Server Standard
SQL: Microsoft SQL 2000 Standard - Using a Case-Sensitive Dictionary Order
TSM: TSM 5.1.1
TDP: TDP 2.2.1
Server Name: MBPARC01
Errors from sqlincremental log file. This is a sample from one instance
that is typical - lots and lots of the same messages for different DB's -
Both Full and Incremental.
03/02/2004 00:52:05 Backup of CARRIER_INFO_FY03 failed.
03/02/2004 00:52:05 ACO5422E Received the following from the MS SQL server:
03/02/2004 00:52:05 [Microsoft][ODBC SQL Server Driver][Named
Pipes]ConnectionRead (WrapperRead()).
03/02/2004 00:52:05 [Microsoft][ODBC SQL Server Driver][Named Pipes]General
network error. Check your network documentation.
03/02/2004 00:52:05 [Microsoft][ODBC SQL Server Driver][SQL Server]Processed
94 pages for database 'CARRIER_INFO_FY03', file 'CARRIER_INFO_FY03_Log' on
file 1. Microsoft SQL-DMO (ODBC SQLState: 01000) (HRESULT:0x80040fc3)
03/02/2004 00:52:07 Backup of CARRIER_INFO_FY04 failed.
03/02/2004 00:52:07 ACO5422E Received the following from the MS SQL server:
03/02/2004 00:52:07 [Microsoft][ODBC SQL Server Driver][Named
Pipes]ConnectionRead (WrapperRead()).
03/02/2004 00:52:07 [Microsoft][ODBC SQL Server Driver][Named Pipes]General
network error. Check your network documentation.
03/02/2004 00:52:07 [Microsoft][ODBC SQL Server Driver][SQL Server]Processed
1 pages for database 'CARRIER_INFO_FY04', file 'CARRIER_INFO_FY03_Log' on
file 1. Microsoft SQL-DMO (ODBC SQLState: 01000) (HRESULT:0x80040fc3)
03/02/2004 00:52:11 Backup of CTS_FY02 failed.
03/02/2004 00:52:11 ACO5422E Received the following from the MS SQL server:
03/02/2004 00:52:11 [Microsoft][ODBC SQL Server Driver][Named
Pipes]ConnectionRead (WrapperRead()).
03/02/2004 00:52:11 [Microsoft][ODBC SQL Server Driver][Named Pipes]General
network error. Check your network documentation.
03/02/2004 00:52:11 [Microsoft][ODBC SQL Server Driver][SQL Server]Processed
84 pages for database 'CTS_FY02', file 'CTS_FY02_Log' on file 1. Microsoft
SQL-DMO (ODBC SQLState: 01000) (HRESULT:0x80040fc3)
03/02/2004 00:52:14 ACO0302E A failure occured on stripe number (0), rc =
200
03/02/2004 00:52:14 ACO0004E An unknown error has been detected.
Errors from SQL Logs:
2004-03-02 00:52:04.99 backup BACKUP failed to complete the command USE
master BACKUP LOG [CARRIER_INFO_FY03] TO
VIRTUAL_DEVICE=N'TDPSQL-00001234-0000' WITH BLOCKSIZE=512,
MAXTRANSFERSIZE=1048576, NAME=N'log', DESCRIPTION=N'TDPSQL-00001234-0000
(TDP MS SQL V2)'
2004-03-02 00:52:06.73 spid51
BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device
'TDPSQL-00001234-0000'. Operating system error 995(The I/O operation has
been aborted because of either a thread exit or an application request.).
2004-03-02 00:52:06.73 backup BACKUP failed to complete the command USE
master BACKUP LOG [CARRIER_INFO_FY04] TO
VIRTUAL_DEVICE=N'TDPSQL-00001234-0000' WITH BLOCKSIZE=512,
MAXTRANSFERSIZE=1048576, NAME=N'log', DESCRIPTION=N'TDPSQL-00001234-0000
(TDP MS SQL V2)'
2004-03-02 00:52:09.66 backup Log backed up: Database: CTS, creation
date(time): 2004/02/26(11:05:29), first LSN: 52463:1771:1, last LSN:
52463:1773:1, number of dump devices: 1, device information: (FILE=1,
TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001234-0000'}).
2004-03-02 00:52:11.66 spid51
BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device
'TDPSQL-00001234-0000'. Operating system error 995(The I/O operation has
been aborted because of either a thread exit or an application request.).
2004-03-02 00:52:11.66 backup BACKUP failed to complete the command USE
master BACKUP LOG [CTS_FY02] TO VIRTUAL_DEVICE=N'TDPSQL-00001234-0000' WITH
BLOCKSIZE=512, MAXTRANSFERSIZE=1048576, NAME=N'log',
DESCRIPTION=N'TDPSQL-00001234-0000 (TDP MS SQL V2)'
2004-03-02 00:52:14.82 spid51
BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device
'TDPSQL-00001234-0000'. Operating system error 995(The I/O operation has
been aborted because of either a thread exit or an application request.).
These DB's were migrated from a single SQL 7 server. During the migration
we split the DB's into separate instances based on usage. Backups worked
just previos to the migration (Windows 2000 server with SQL 7 and TDP 2.2.1)
Thanks,
Kevin
|