ADSM-L

Error restoring SQL full backup

2004-05-17 11:14:49
Subject: Error restoring SQL full backup
From: "Lambelet,Rene,VEVEY,GLOBE Center CSC" <Rene.Lambelet AT NESTLE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 17 May 2004 17:14:06 +0200
Hello dear TSM'ers

trying to restore a full backup of one of our SQL servers, we get following
error message :

> 05/17/2004 13:48:20 ACO5456W The backup is corrupt and is not fully
> restorable.
> 05/17/2004 13:48:20 Processing will continue.
> 05/17/2004 13:48:21 Restore of CTR_HQ_GLOBE_DV failed.
> 05/17/2004 13:48:21 [Microsoft][ODBC SQL Server Driver][SQL Server]The
> volume on device 'TDPSQL-00002374-0000' is empty.
> 05/17/2004 13:48:21 [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE
> DATABASE is terminating abnormally.
> 05/17/2004 13:48:21 Total database backups inspected:               1
> 05/17/2004 13:48:21 Total database backups requested for restore:   1
> 05/17/2004 13:48:21 Total database backups restored:                0
> 05/17/2004 13:48:21 Total database skipped:                         0
> 05/17/2004 13:48:21 Throughput rate:                                0.00
> Kb/Sec
> 05/17/2004 13:48:21 Total bytes transferred:                        0
> 05/17/2004 13:48:21 Elapsed processing time:                        0.53
> Secs
> 05/17/2004 13:48:21 ACO0151E Errors occurred while processing the request.
> 
> 
Any tips to solve this problem ? Looking on the adsm.org did not help yet.

We use tsm server AIX 5.1.5.4, client NT 5.1.5.9, Tdp for SQL 5.1.5.0,

SQL is in version SQL2000, SP3

thanks a lot

                René LAMBELET
                NESTEC  SA
                GLOBE - Global Business Excellence
                Central Support Center
                SD/ESN
                Av. Nestlé 55  CH-1800 Vevey (Switzerland) 
                tél +41 (0)21 924'35'43   fax +41 (0)21 924'45'89   local
REL-5 01
                mailto:rene.lambelet AT nestle DOT com

                This message is intended only for the use of the addressee
                and may contain information that is privileged and
confidential.

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