Rick, The select below suitably tailored for node_name and backup_date will tell you what was in that backup
SELECT HL_NAME,LL_NAME FROM BACKUPS - WHERE NODE_NAME='YOURNODE' - AND BACKUP_DATE BETWEEN '2005-01-04 21:00' AND '2005-01-05 07:00' John Rick Harderwijk <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> 05/01/2005 12:53 Please respond to "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> To ADSM-L@vm.marist.edu cc Subject What does it backup? Hi all, I was just checking my activity log on my TSM 4.2 server and noticed something odd. One of the clients (W2K server with Oracle + an imagebank) did a backup of 2588 files, amounting to almost 9Gb. I know not that many data modifies in a single day so I checked to be sure, and indeed: only 707 files (393Mb) were modified. My next guess was that, for some reason, the Oracle datafiles or backuplogs where backed up (normal Oracle backup runs through TDP as a seperate job) but when I did a point-in-time check, no oracle datafiles were found - and there shouldn't be, as they are excluded from regular backup in dsm.opt. Can anyone tell me how I can check what files it actually did backup? I really want to know what that data is... Kind regards, Rick Harderwijk Systems Administrator ********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy Group. 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. Unless specifically stated otherwise, this email (or any attachments to it) is not an offer capable of acceptance or acceptance of an offer and it does not form part of a binding contractual agreement. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **********************************************************************
