Re: restoring TSM DB

That is correct.
The log is cleared/reset each time you do a TSM DB backup; ALL the
current information is on the DB backup tape.

-If you lose your TSM DB, but your log is still intact AND you are
running with the log in ROLLFORWARD mode, you can restore your DB from
the last DB backup and roll forward from the recovery log to the point
of failure.

-If you lose your TSM DB, your log is still intact, but you are running
with the log in NORMAL mode, you can still only restore your DB from the
time of the last DB backup; you lose everything since the last DB
backup.

-If you have lost BOTH the db and recovery log, you can only restore
back to the point of your last DB backup.

So with the dsmfmt you must reinitialize the DB and the recovery log
volumes.
TSM will reformat the recovery log as part of the DB restore.

Hope that helps.

Wanda Prather
"I/O, I/O, It's all about I/O"  -(me)




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Krzysztof Kus
Sent: Wednesday, September 14, 2005 8:07 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: restoring TSM DB


Hello.

In the TSM administrator guide (5.3) I have found that:

"Attention: If the original database or recovery log volumes are
available, you issue only the DSMSERV RESTORE DB utility. However, if
those volumes have been lost, you must first issue the DSMSERV FORMAT
command to initialize the database and recovery log, then issue the
DSMSERV RESTORE DB utility."

Does it mean that after db loss I need to do:
- dsmfmt
- dsmserv restore db
only?

No copying transaction log, no overwriting log during dsmserv format, no
copying back proper log are needed?

Best regards,
Krzysztof Kus