ADSM-L

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

2011-01-03 10:13:33
Subject: [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: Mon, 3 Jan 2011 10:12:36 -0500
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>