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." - ??
