Hello Zoltan,


The "ANS1688I Sparse attributes" message should not be related to
the problems you are seeing with your DP/SQL backups.


The other messages having to do with
   "CSqlApi::GetSqlDatabaseInfoOpt3:6765:1914 LogFiles Count:0"
may have to do with some optimization that was added with DP/SQL 5.5.5.

You can turn this off by adding:
        QUERYOPTimization  0
to the TDPSQL.CFG file.

to see if it allows the backups to work successfully.

Either way, please open a problem with IBM support as it seems you
may have a unique setup that is causing this issue.


Thanks,

Del

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

"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 01/03/2011
10:12:36 AM:

>> From: Zoltan Forray/AC/VCU <zforray AT VCU DOT EDU>
>> To: ADSM-L AT vm.marist DOT edu
>> Date: 01/03/2011 10:13 AM
>> Subject: Strange errors from MSSQL/TDP backups
>> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>>
>> Getting these strange errors (so strange that Google returns NO RESULTS
>> even when searching for just the ANS1688I part of the message)
>>
>> 01/02/2011 22:22:30 ANS1688I Sparse attributes for 'D:\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\msdbdata.mdf' cannot be backed up correctly
>> because the volume from which the file is backed up does not support
>> sparse files.
>>
>> My SQL guy is reporting ACO5422E errors (yeah, I know - generic error
>> message usually related to permissions issues)  along with these I
found
>> in one of the SQL backup logs:
>>
>> 01/02/2011 04:00:07 Backup of SQL Database millreports_05032010 will
not
>> be attempted.
>> 01/02/2011 04:00:07 ACO5422E Received the following from the MS SQL
>> server:
>> 01/02/2011 04:00:07 CSqlApi::GetSqlDatabaseInfoOpt3:6765:1914 LogFiles
>> Count:0
>> 01/02/2011 04:00:07 Backup of SQL Database millreports will not be
>> attempted.
>> 01/02/2011 04:00:07 ACO5422E Received the following from the MS SQL
>> server:
>> 01/02/2011 04:00:07 CSqlApi::GetSqlDatabaseInfoOpt3:6765:1914 LogFiles
>> Count:0
>> 01/02/2011 04:00:07 Backup of SQL Database VCU_05032010 will not be
>> attempted.
>> 01/02/2011 04:00:07 ACO5422E Received the following from the MS SQL
>> server:
>> 01/02/2011 04:00:07 CSqlApi::GetSqlDatabaseInfoOpt3:6765:1914 LogFiles
>> Count:0
>> 01/02/2011 04:00:07 Backup of SQL Database VCU will not be attempted.
>> 01/02/2011 04:00:07 ACO5422E Received the following from the MS SQL
>> server:
>> 01/02/2011 04:00:07 CSqlApi::GetSqlDatabaseInfoOpt3:6765:1914 LogFiles
>> Count:0
>> 01/02/2011 04:00:07 Backup of SQL Database AdventureWorks will not be
>> attempted.
>> 01/02/2011 04:00:07 ACO5422E Received the following from the MS SQL
>> server:
>> 01/02/2011 04:00:07 CSqlApi::GetSqlDatabaseInfoOpt3:6765:1914 LogFiles
>> Count:0
>>
>> Base TSM client is 6.2.2.0
>> TDP is 5.5.5.0
>>
>> SQL admin noted the problems started with the 5.5.5.0 update
>>
>> Any clues?
>> Zoltan Forray
>> TSM Software & Hardware Administrator
>> Virginia Commonwealth University
>> UCC/Office of Technology Services
>> zforray AT vcu DOT edu - 804-828-4807
>> Don't be a phishing victim - VCU and other reputable organizations will
>> never use email to request that you reply with your password, social
>> security number or confidential personal information. For more details
>> visit http://infosecurity.vcu.edu/phishing.html