SQL excludes at tdp version 5.1.5
2003-06-27 10:57:33
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- SQL excludes at tdp version 5.1.5,
Frost, Dave <=
|
|
|