> 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 so, there was an internal limit on the number of databases that could be queried at one time. The README file documents it like this: - Limit to TSM database queries When querying TSM for the databases that have been backed up, there is a limit on the number that will be displayed due to internal buffer limitations. When querying TSM for more than 500 or so databases, it is possible that the limit will be exceeded. In order to view the remaining databases, some of the database backups that are shown will have to be deleted. This usually would occur when old backups were not deleted from TSM server storage using the /ADSMDELETE or /ADSMAUTODELETE commands. In order to see the rest of the database backups, you will have to delete some of your older backups, using the command above or the GUI. TDP for SQL version 2 no longer has this limitation. In addition, version 2 "officially" supports SQL 2000. (TDP for SQL version 1 does not support SQL 2000.) Thanks, Del ---------------------------------------------------- Del Hoobler IBM Corporation [EMAIL PROTECTED] "Life is short but sweet for certain..." -- Dave
