ADSM-L

Re: [ADSM-L] Strange errors from MSSQL/TDP backups

2011-01-06 11:25:14
Subject: Re: [ADSM-L] Strange errors from MSSQL/TDP backups
From: Zoltan Forray/AC/VCU <zforray AT VCU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 6 Jan 2011 11:23:35 -0500
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

<Prev in Thread] Current Thread [Next in Thread>