Re: Starting a Snapshot of a Database

From: Maxim S. Shatskih <maxim_at_storagecraft.com>
Date: Sat, 12 Apr 2003 16:57:43 +0400
Message-ID: <b79ogg$27ek$1@gavrilo.mtu.ru>

> Has anyone here some experience making snapshots of databases? These

Is it reliable? Snapshot will not guarantee the transaction boundaries, i.e. the data integrity. Why not use the DB's native backup tools like DUMP DATABASE and DUMP TRAN?

If you're insisting on using snapshots - then try the snapshotting product which will allow "write inactivity timeout" - i.e. will apply snapshot only after there was no writes to the volume for, say, 5 seconds. In practice, this will usually provide the integrity, though no 100% guarantee.

Max Received on Sat Apr 12 2003 - 07:57:43 CDT