SQLServer 2005 on Windows2003.

TSM Server 5.5.0.3 on Windows2003.

TDP Sql 5.5.0.0





There are 3 databases on this SQLServer that are mirrors from another (not a
cluster) and I have them specified in the DSM.OPT to be excluded. During the
BACKUP * FULL I receive errors about the status of the databases as
"Restoring" even though I specified that the be excluded. Thus giving me the
402 return code. I want to backup all the databases EXCEPT for these without
getting error conditions on the ones I've excluded.



Exclude  "\...\NobelADX\...\*"

Exclude  "\...\SchoolsLookup\...\*"

Exclude  "\...\TheTouchStoneSchools_ADX\...\*"



These are the error messages:



Backup of SQL Database NobelADX will not be attempted.

SQL Database Status: Restoring

ACO5422E Received the following from the MS SQL server:

An exception occurred while executing a Transact-SQL statement or batch.

The database "NobelADX" cannot be opened. It is acting as a mirror database.
(HRESULT:0x80131501)



I don't want it to be attempted..that's why I excluded them!! Looking at the
database status in SQLServer is shows as "Mirror, Synchronized / Restoring",



Any help will be very much appreciated.



Bill Boyer

" Artificial Intelligence is no match for Natural Stupidity." - ??