Re: Error restoring SQL full backup
2004-05-17 11:57:17
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
|
|
|