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 [email protected] - 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 <[email protected]> To: [email protected] Date: 01/05/2011 03:53 PM Subject: Re: [ADSM-L] Strange errors from MSSQL/TDP backups Sent by: "ADSM: Dist Stor Manager" <[email protected]> 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" <[email protected]> wrote on 01/03/2011 10:12:36 AM: >> From: Zoltan Forray/AC/VCU <[email protected]> >> To: [email protected] >> Date: 01/03/2011 10:13 AM >> Subject: Strange errors from MSSQL/TDP backups >> Sent by: "ADSM: Dist Stor Manager" <[email protected]> >> >> 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 >> [email protected] - 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
