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
