Andy/Chaps,

Well, it looks like what we're going to do is set up a separate TSM
instance and have it share the tape library.  Then we will copy our onsite
pool from the main instance to this other instance.  After the copy we run
a PREPARE, eject the tapes, shut the thing down, send it off site and then
remove it from the server.

It's a modification of Steve Harris's idea but separating it into a
separate instance means that we don't have to recover the entire TSM
server just to recover year-end data.

We have to make sure the copies are complete by the end of the month as
the backup data has a 32 day expiration set (although we could change this
if we get into trouble but then we have more data to copy).

So, to summarise:
* create a new tsm instance
* have it share the library
* export the data from our primary pool to the new instance's primary pool
* backup the db
* run PREPARE on the new instance
* eject all the tapes
* gift-wrap and send offsite
* shut down and remove the instance from the server

To restore, we would need to do this:
* recall the dr plan and tapes from offsite
* reconstruct the new instance
* restore

This is what we're working on now.  It's not nice - too much data is
copied across - but at least we get everything that we need to get.

Mark


--
Mark Ferraretto
Unix Systems Administrator - Unix support hotline:  +852 2203 6369
Deutsche Bank Hong Kong
w: +852 2203 6362        m: +852 9558 8032        f: +852 2203 6971
mark.ferraretto AT db DOT com




andy.wilcox AT AQUILA-NETWORKS.CO DOT UK
Sent by: ADSM-L AT VM.MARIST DOT EDU
08/01/2004 23:21
Please respond to ADSM-L


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Taking an end-of-year snapshot


This isn't exactly a solution but I have the very same problem as yourself
in finding the best way of doing this, and as you have pointed out, there
is
no easy way that we have found. It is lookin very much like we will have
to
make our TSM service unavailable for a "long-weekend" to be able to carry
out the snapshots.

How have you got on with your snapshot Mark? Have you found any gotchas
worth sharing? Has anyone else had to overcome this issue and found a less
disruptive way of doing it?

Many thanks

Andy Wilcox
UNIX Systems Administrator
Aquila Networks


-----Original Message-----
From: Mark Ferraretto [mailto:mark.ferraretto AT DB DOT COM]
Sent: 06 January 2004 03:59
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Taking an end-of-year snapshot


All,

We are running TSM 5.1.6.1 on AIX 5.1

What I want to do is to take an snapshot of our TSM data as it was at end
of year 1/1/04 and archive it away for 10 years.  Is this possible?  I
haven't found a way of doing it.

We need to make an end-of-year archive each year for legal etc purposes.
Running an archive of everything on one day doesn't seem practical - too
much data coming into the server.  But snapshotting the existing backup
data would be ideal.

I was thinking that I could generate a backup set and backdate the
snapshot the backup set would take but there doesn't seem to be an option
to do this.

Does anyone know how this can be done?

Thanks

Mark


--
Mark Ferraretto
Unix Systems Administrator - Unix support hotline:  +852 2203 6369
Deutsche Bank Hong Kong
w: +852 2203 6362        m: +852 9558 8032        f: +852 2203 6971
mark.ferraretto AT db DOT com


****************************************************************************
************************
Confidentiality: This e-mail and any files transmitted with it are
confidential and intended solely for the use of the individual or entity
to
whom they are addressed.  If you have received this e-mail in error, use
of
this information (including disclosure, copying or distribution) may be
unlawful.  Please notify postmaster AT aquila-networks.co DOT uk. and delete the
message immediately.

Security: Internet e-mail is not a 100% secure communications medium.

Viruses: This e-mail (and any attachments) has been checked (using Sophos
Sweep 3.68 + patches) and found to be clean from any virus infection
before
leaving.
Therefore neither Aquila Networks Services Ltd nor Midlands Electricity
plc
or any of their group undertakings  (as defined by the Companies Act 1989)
(together referred to as the "Companies") accept legal responsibility for
this message or liability for the consequences of any computer viruses
which
may have been transmitted by this e-mail.

Monitoring: All electronic communications with the Companies may be
monitored in accordance with the UK Regulation of Investigatory Powers
Act,
Lawful Business Practice Regulations, 2000.  If you do not consent to such
monitoring, you should contact the sender of this e-mail.

Aquila Networks Services Limited,
Registered office: Whittington Hall, Whittington, Worcester, WR5 2RB
Registered in England and Wales number 3600545
This e-mail may be sent on behalf of any of the Companies.
****************************************************************************
************************


****************************************************************************************************
Confidentiality: This e-mail and any files transmitted with it are
confidential and intended solely for the use of the individual or entity
to whom they are addressed.  If you have received this e-mail in error,
use of this information (including disclosure, copying or distribution)
may be unlawful.  Please notify postmaster AT aquila-networks.co DOT uk. and
delete the message immediately.
Security: Internet e-mail is not a 100% secure communications medium.
Viruses: This e-mail (and any attachments) has been checked (using Sophos
Sweep 3.74 + patches) and found to be clean from any virus infection
before leaving.
Therefore neither Aquila Networks Services Ltd nor Midlands Electricity
plc  or any of their group undertakings  (as defined by the Companies Act
1989) (together referred to as the "Companies") accept legal
responsibility for this message or liability for the consequences of any
computer viruses which may have been transmitted by this e-mail.

Monitoring: All electronic communications with the Companies may be
monitored in accordance with the UK Regulation of Investigatory Powers
Act, Lawful Business Practice Regulations, 2000.  If you do not consent to
such monitoring, you should contact the sender of this e-mail.
Aquila Networks Services Limited,
Registered office: Whittington Hall, Whittington, Worcester, WR5 2RB
Registered in England and Wales number 3600545
This e-mail may be sent on behalf of any of the Companies.
****************************************************************************************************