Basic question:

Can I clone or snapshot an MS SQL 7 database and then take hourly
"incremental" backups and do the following restore:

restore the clone (either from tape or from the clone itself) and apply the
"incremental" restores?

I'm after a rather quick restore of a large database.  Perhaps between 150
and 500 GB.  I thought to use TDP or simply capture the logs by cloning or
snapshot or via the ba client.

Would I be better off simply snapshotting once per hour and leaving TSM out
of the picture?  Perhaps backing up the snapshot periodically for DR
purposes?  This customer wants to be able to get to a previous state of the
database but not go back 24 hours.  Loss of an hour's worth of data is
acceptable, but not 24.  What are others doing to meet this sort of a
requirement?

TIA,

Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719) 531-5926
Fax: (719) 260-5991
Email: lipp AT storsol DOT com
www.storsol.com
www.storserver.com