Sure - it works great. My only caveat would be to make sure that your system is quiesced before you take the snapshot to avoid "fuzziness". There's a good writeup on doing the recovery in the Administrator's Guide.
"Davidson, Becky" <[EMAIL PROTECTED]> wrote:Can you use a db snapshot to recover a database in a dr situation? I can't think of why not but I would rather be safe then sorry. Thanks! Becky Davidson Data Manager EDS/Sara Lee Bakery Group voice: 314-259-7589 fax: 314-877-8589 email: [EMAIL PROTECTED] Joe Howell Shelter Insurance Companies Columbia, MO --------------------------------- Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes