I can't speak for the other DBs, but in Oracle you would try and use 2GB or 4GB datafiles.  If there's a corrupt block, you'd only need to goto
.snapshot/hourly.0 and copy that one 2GB file back to the active filesystem, then start a point-in-time recovery. 
SnapRestore when you have a major meltdown or when small number of spindle volumes don't matter, such as in development environments.
-----Original Message-----
From: Egner, Michael [mailto:Michael.Egner@netapp.com]
Sent: Tuesday, September 04, 2001 3:27 PM
To: Jamey Maze; Jay Newton; 'toasters@mathworks.com'
Subject: RE: Snapshots of QTREEs

Correct.  But if you use SnapRestore to restore one of those snapshots, then you restore ALL of the databases on that volume back to that point in time.
 

-Mike Egner
System Engineer
Network Appliance

 
-----Original Message-----
From: Jamey Maze [mailto:maze@cs.utk.edu]
Sent: Tuesday, September 04, 2001 3:30 PM
To: Jay Newton; 'toasters@mathworks.com'
Subject: Re: Snapshots of QTREEs

When you create a snapshot, it's the entire volume. But with 6.x, you've got 31 snapshots to play with so you can use different snapshots for different databases. Make sense?

At 03:04 PM 9/4/2001 -0500, Jay Newton wrote:

Is there a way to snapshot an individual QTREE from command line or must it be the entire volume.  I have a volume set up for databases and I want to snapshot from command line individual QTREEs that represent different types of databases.  Any help would be appreciated!

Jay Newton
Systems Engineer - Chesapeake Operating
(405)810-2683
(405)879-9578 fax