This will get you backups still in existence between those dates

SELECT HL_NAME,LL_NAME FROM BACKUPS -
WHERE NODE_NAME='YOURNODE' -
AND BACKUP_DATE BETWEEN '2002-11-01' AND '2002-12-07'







"Cahill, Ricky" <ricky.cahill AT equitas.co DOT uk> on 01/28/2003 03:23:39 PM

Please respond to "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>

To:   adsm-l AT vm.marist DOT edu
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  Little help from the select statement wizzies...



I have a need to find any data still in existance from 7/12/2002 back to
01/11/2002 and on what volumes it resides.
I realise the only way I'm going to find this is by select but havn't really
played with them much at all, would anyone have any idea of how to do this?

Thanks in advance.

                        .............Rikk


****************************************************************************************************

Equitas Limited, 33 St Mary Axe, London EC3A 8LL, UK
NOTICE: This message is intended only for use by the named addressee
and may contain privileged and/or confidential information.  If you are
not the named addressee you should not disseminate, copy or take any
action in reliance on it.  If you have received this message in error
please notify postmaster AT equitas.co DOT uk and delete the message and any
attachments accompanying it immediately.

Equitas reserve the right to monitor and/or record emails, (including the
contents thereof) sent and received via its network for any lawful business
purpose to the extent permitted by applicable law

Registered in England: Registered no. 3173352 Registered address above
****************************************************************************************************








**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************