Paul and co,
The TSM server I am administering is not running any tape drives through
the TSM component - all data which is backed up to this server is being
sent straight to diskpools (to a whopping great SAN). On a monthly basis I
generate backupsets for each node and send these to another volume in the
SAN which is then backed up using third party backup tools (Omniback I
think). This way there is close to instant retrieval of data for the last
thirty days and I have monthly backups for archival purposes. This is
different to any other TSM server I have administered, but as of today has
been working without a problem.
Thanks all for the input into my problem. I now have enough to go on with
and get my estimates.
Regards,
------------------------------------------------------------------------------
Graham Trigge
IT Technical Specialist
Server Support
Telstra Australia
Phone: (02) 9882 5831
Fax: (02) 9882 5993
Mobile: 0409 654 434
"Seay, Paul"
<seay_pd@NAPT To: ADSM-L AT VM.MARIST DOT EDU
HEON.COM> cc:
Sent by: Subject: Re: Estimating size of
backup sets
"ADSM: Dist
Stor Manager"
<ADSM-L AT VM DOT MA
RIST.EDU>
14/02/2003
10:29 PM
Please
respond to
"ADSM: Dist
Stor Manager"
This will give you the filespace usage, which is the active backupset size
except it includes excluded data. It should be good enough for an estimate.
select node_name, cast(sum(capacity*pct_util/100) as decimal(10,3)) as "MB
of Used" from filespaces group by node_name
However, I am not sure how you are going to get this done. Are you
creating
these for faster recovery from the server or for standalone on a CD? If it
is from the server, you may think about collocation by node.
Paul D. Seay, Jr.
Technical Specialist
Northrop Grumman Information Technology
757-688-8180
-----Original Message-----
From: Halvorsen Geirr Gulbrand [mailto:gehal AT WMDATA DOT COM]
Sent: Friday, February 14, 2003 5:02 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Estimating size of backup sets
I agree with John, this sounds very ambitious.
If you are only interested in active files, there is the possibility of
checking it on the actual client, how much data in each filespace
(filesystem/drive/etc). A worst case (it gives all backup-data, active and
inactive) could be "q occ t=b"
Rgds,
Geirr G. Halvorsen
-----Original Message-----
From: John Naylor [mailto:john.naylor AT SCOTTISH-SOUTHERN.CO DOT UK]
Sent: 14. februar 2003 10:58
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Estimating size of backup sets
Graham,
Your plan is extremely ambitious.
Is this a one off or are are you planning to do this regularly. How are you
goung to achieve this. Anyway you can get a reasonable idea from taking the
filepace occupancy, unless you have major excludes from backup, this is
going to be your active file size. John
Graham Trigge <graham_trigge AT enterpriseservices.com DOT au> on 02/13/2003
10:35:24 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: Estimating size of backup sets
TSMers,
Is there anyway people know of to estimate how large a backupset is going
to
be? I have close to 700 nodes I want to generate backupsets for and I want
to know what sort of space I will be using up with them. I am assuming it
will be some sort of SQL statement looking at active files, but I can't
figure it out past that.
Any help would be appreciated.
Regards,
----------------------------------------------------------------------------
--
Graham Trigge
IT Technical Specialist
Server Support
Telstra Australia
Phone: (02) 9882 5831
Fax: (02) 9882 5993
Mobile: 0409 654 434
----------------------------------------
The information contained in this e-mail and any attachments to it:
(a) may be confidential and if you are not the intended recipient, any
interference with, use, disclosure or copying of this material is
unauthorised and prohibited. If you have received this e-mail in error,
please delete it and notify the sender;
(b) may contain personal information of the sender as defined under the
Privacy Act 1988 (Cth). Consent is hereby given to the recipient(s) to
collect, hold and use such information for any reasonable purpose in the
ordinary course of TES' business, such as responding to this email, or
forwarding or disclosing it to a third party.
**********************************************************************
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.
**********************************************************************
|
