Author: "Blair, Georgia" <georgia.blair AT USAA DOT COM>
Date: Wed, 10 Jul 2002 11:27:38 -0500
I had a user trying to restore a database and found data unavailable to server. The restore was asking for a volume that was offsite. Why wouldn't it ask for the primary copy and how do I know what p
Author: Mark Stapleton <stapleto AT BERBEE DOT COM>
Date: Wed, 10 Jul 2002 12:00:27 -0500
Read the server activity log to see which primary pool tape it was trying to get. Once you've got the volume number, check the status and storage pool of the tape (Q VOL F=D) and its physical locatio
Author: "Blair, Georgia" <georgia.blair AT USAA DOT COM>
Date: Wed, 10 Jul 2002 13:16:05 -0500
I probably didn't make this clear I don't know the primary volume # or how to find it. The restore requested a volume that was physically offsite in the vault. I would think it would ask for the prim
Author: Dirk Kastens <Dirk.Kastens AT UNI-OSNABRUECK DOT DE>
Date: Thu, 11 Jul 2002 09:00:37 +0200
Hi, You can use an SQL statement, like select distinct volume_name,stgpool_name from volumeusage - where node_name='YOUR_CLIENT_NODE_NAME' - order by volume_name Maybe the volume has been disabled or
Author: Ruksana Siddiqui <Ruksana.Siddiqui AT AMCOR.COM DOT AU>
Date: Thu, 11 Jul 2002 18:04:06 +1000
Dirk, node_name is not recognized. ANR2940E The reference 'NODE' is an unknown SQL column name. .............................V................................. _name from volumeusage where node-name=