Re: [ADSM-L] Spurious error message with TSM for Databases (SQL)

I asked this question a while back, and supposedly there was going to be a
fix in an upcoming TDP for SQL release. Del, is that release out? Thanks!

BTW, my way of solving was deleting the database, since the ones in my
situation were no longer going to be used. That doesn't seem to be your case.
:)

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Mark
Stapleton
Sent: Friday, March 23, 2007 9:10 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Spurious error message with TSM for Databases (SQL)

When I use the SQL agent (version 5.3.3.0) to back up SQL2000 databases on a
Windows 2000 server, and the SQL machine has one or more databases offline, I
get this error message:
 
Backup of SQL Database RefTables will not be attempted.
SQL Database Status: StatusError768
ACO5422E Received the following from the MS SQL server:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'RefTables' cannot be
opened because it is offline. Microsoft SQL-DMO (ODBC SQLState: 42000)
(HRESULT:0x800403ae)

(RefTables is the offline database) in the sqlsched.log and a false FAILED
backup report in TSM Operational Reporter. (Everything else backed up just
dandy.) I excluded the full and log backups for this database with
 
     EXCLUDE "\...\RefTables\...\*"
 
to no avail.
 
Is there any way to avoid this; log backups every 2 hours means this client
generates 12 failures every day.
 
--
Mark Stapleton (mark.s AT evolvingsol DOT com)
Senior consultant
-----------------------------------------
Confidentiality Notice:
The information contained in this email message is privileged and
confidential information and intended only for the use of the
individual or entity named in the address. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this information is strictly
prohibited. If you received this information in error, please
notify the sender and delete this information from your computer
and retain no copies of any of this information.