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" <[email protected]> wrote on 01/06/2011 11:23:35 AM: >> From: Zoltan Forray/AC/VCU <[email protected]> >> To: [email protected] >> Date: 01/06/2011 11:25 AM >> Subject: Re: Strange errors from MSSQL/TDP backups >> Sent by: "ADSM: Dist Stor Manager" <[email protected]> >> >> 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
