ADSM-L

Re: Error restoring SQL full backup

2004-05-17 11:57:17
Subject: Re: Error restoring SQL full backup
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 17 May 2004 11:57:07 -0400
René,

As you may know, a single Data Protection for SQL backup
is made up of multiple objects on the TSM Server.
This error message means that the the number of objects that
make up the specific object you are trying to restore
is not correct. This should not normally happen, but may occur 
if there have been deleted/corrupted/lost TSM Server objects 
due to bad/lost tapes.

I recommend that you call IBM support so that a trace can be
obtained to find out exactly what objects are incorrect.

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 05/17/2004 
11:14:06 AM:

> 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

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