> I'm testing backup and restore of SQL databases of SQL Server 8.00 and
7.00
> .
>The backups as no problems but when I do a restore I get the following
error
>
> ACO2590W -- The amount of data exceeds the available buffer space for
this
> query.
Hugo,
Are you using TDP for SQL version 1? If s
We just ran into the same problem on a 60GB database that we were attempting
to restore to another server. The problem ended up that the SQL server had
"reconstruction" processing that it needed to perform as part of the restore
and (in our case) was going to take from 4 to six hours. The proble
I highly recommend contacting Tivoli supportIn the mean time, you
should
run a trace of the restore (/TRACEFILE=someFileName, /TRACEFLAGS=ALL,API)
in order to determine which SQL api call you are hanging on...As this will
be needed by
tivoli support
You should also look at the SQL log and
