Hi,

> 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 primary
> volume the data
> is on?

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 changed to readonly due
to a write or read error.

Dirk