Hi Zoltan,

I am glad the option resolved the problem.

We would very much appreciate it if you could open a PMR for this.
We would like to gather traces to find out exactly what is going on here.
i.e. whether it is a missing SQL Server fix, a missing prereq,
or simply a scenario that the optimization code did not account for.


Thanks,

Del

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


"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 01/06/2011
11:23:35 AM:

>> From: Zoltan Forray/AC/VCU <zforray AT VCU DOT EDU>
>> To: ADSM-L AT vm.marist DOT edu
>> Date: 01/06/2011 11:25 AM
>> Subject: Re: Strange errors from MSSQL/TDP backups
>> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>>
>> Adding the QUERYOPTimization option fixed it.  Not sure what we have
that
>> is "unique" that could cause this.  We try to stay pretty vanilla when
it
>> comes to setups and configs.
>>
>> Thanks, Del
>> 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
>>


From:
Del Hoobler <hoobler AT US.IBM DOT COM>
To:
ADSM-L AT VM.MARIST DOT EDU
Date:
01/05/2011 03:53 PM
Subject:
Re: [ADSM-L] Strange errors from MSSQL/TDP backups
Sent by:
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



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