ADSM-L

SQL Backup errors with TDP 2.2.1

2004-03-02 20:18:02
Subject: SQL Backup errors with TDP 2.2.1
From: Kevin Jarrard <kjarrard AT YCI DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 2 Mar 2004 17:02:43 -0800
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

<Prev in Thread] Current Thread [Next in Thread>