What is probably missing as a bit of extra information is that the restore involves the ENTIRE database, OFFLINE. There is no such thing as partial restores, partial backups, incremental backups or partial recovery with SS2K. It's all or nothing. And when all is being restored, you're out for the duration. Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxxxxx ----- Original Message ----- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx> > > Thanks Niall, only confirming, sql server YES have hot backups.? > Defining hot backup as the ability to backup whilst the database is available for use then yes. > http://activeanswers.compaq.com/aa_downloads/6/100/225/1/38758.pdf > > Is a hardware vendor's test case. > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------