SQL and Exchange replication

[techfreakz]

Hi there,

I believe if a database exists on a filesystem that is being snapshot'd, then that database must be VSC-aware and flush its data to disks on demand when signalled to do so before a snapshot can complete. This happens typically inside the MS OS eco-system.

Since the DSS snapshot process is not in anyway coupled in to the MS VSC subsystem running on your database server, I would suspect the answer is no to your question.

A work around may be use a VSS aware backup utility like BackupAssist to intiate a VSC snapshot, whereupon the database will flush its buffers to disk, snapshot, then backup to another share or volume on the DSS server, then have that volume replicated to another location.

I guess it'd be useful to have a windows service agent that communicates with the DSS server and signals your VSC-aware application when a snapshot is imminent....

Best regards

AS

[asingh]

I hear what your saying with the "flush its data to disks on demand when signalled to do so before a snapshot can complete. This happens typically inside the MS OS eco-system."

However we also have Equallogic systems and they handle the SQL snapsot as needed so there are no problems. With no agent on Microsoft system.


Thanks
Aneil

[asingh]

I hear what your saying with the "flush its data to disks on demand when signalled to do so before a snapshot can complete. This happens typically inside the MS OS eco-system."

However we also have Equallogic systems and they handle the SQL snapshot as needed with no problems. No agent on Microsoft system is needed with the Equallogics, the equallogics handle this all be them selves.


SO the question still is will our Open-e systems handle MS SQL snapshots properly?



Thanks
Aneil