We have a linux shell script which we use to create our offsite copypool tapes. Basically the commands are:
backup stg SQLDB_LTO4 SQLDB_COPYPOOL wait=yes backup stg BKPLTO4POOL COPYPOOL_LTO3 wait=yes Our primary SQL storage pool is SQLDB_DISKPOOL and it's secondary pool for data migration is SQLDB_LTO4. Our primary backup storage pool is BKPPOOL and it's secondary pool for data migration is BKPLTO4POOL. However I am finding that backups of SQL databases are also somehow ending up in the BKPLTO4POOL storage pool because they are then in turn being backed up into the COPYPOOL_LTO3 storage pool. The reason I know this is that these SQL databases are very large files with very distinctive (but consistent) sizes so as soon run "q pr" and see the process copying a 185 Gb file from the BKPLTO4POOL storage pool to the COPYPOOL_LTO3 storage pool I know which SQL database file that is. On the SQL servers I have included the SQL database folder in the Exclude-Include configuration of the normal TSM backup setup. (these databases are backed up using TDP for SQL) As well as that, SQL is running all the time so the normal TSM backup client would never be able to get a lock on these database files. I already have a backup of these SQL databases in the SQLDB_LTO4 storage pool and therefore a copy is in the SQLDB_COPYPOOL storage pool so I don't need another copy in BKPLTO4POOL and COPYPOOL_LTO3 Any idea how I can work out why a backup copy of these SQL database backups are ending up in BKPLTO4POOL and stop this from happening? Thanks & Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: <mailto:pdud...@anl.com.au> pdud...@anl.com.au ANL - Regional Carrier of the Year 2011 - Containerisation International ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.