Hello readers everywhere:

Each night I run a backup of an SQL server
On this server I have an 'off-line' databases called Bob (I know it is case
sensitive)
I have added the following to the dsm.opt for the TDP:
EXCLUDE "\...\Bob\...\*"

The issue is that when the backup runs (using this dsm.opt file) the backup
gives an RC 402 message.
I find the following in the sqlfull.log:
------------------------------------------------------------------------------------------------------------------------------------------------
06/26/2003 01:31:31 Request                       : FULL BACKUP
06/26/2003 01:31:31 Database Input List           : *
.
.
.
06/26/2003 01:31:31 Backup of SQL Database Bob will not be attempted.
06/26/2003 01:31:31 SQL Database Status: Offline
06/26/2003 01:31:31 ACO5422E Received the following from the MS SQL server:
06/26/2003 01:31:31 [Microsoft][ODBC SQL Server Driver][SQL Server]Database
'Bob' cannot be opened because it is offline. Microsoft SQL-DMO (ODBC
SQLState: 42000) (HRESULT:0x800403ae)
06/26/2003 01:32:17 Total SQL backups selected:               8
06/26/2003 01:32:17 Total SQL backups attempted:              7
06/26/2003 01:32:17 Total SQL backups completed:              7
06/26/2003 01:32:17 Total SQL backups excluded:               0
06/26/2003 01:32:17 Total SQL backups inactivated:            28
06/26/2003 01:32:17 Throughput rate:                          5,107.65
Kb/Sec
06/26/2003 01:32:17 Total bytes transferred:                  177,697,136
06/26/2003 01:32:17 Elapsed processing time:                  33.98 Secs
06/26/2003 01:32:17 ACO0151E Errors occurred while processing the request.
06/26/2003 01:32:17 ACO0151E Errors occurred while processing the request.
------------------------------------------------------------------------------------------------------------------------------------------------

My findings so far it that the exclude statement I have used in the dsm.opt
works if the database is on-line.  It is only if the database is off-line
that I get this message.

Does anyone out there know how to exclude an off-line database from backup?

Regards,

-=Dave=-
+44 (0) 20 7608 7140

The only sensible way to estimate the stability of a Windows server is to
power it down and try it out as a step ladder. - Robert Crawford, in the
Monastery