mount driveletter for replicated volume
Updated: 21 May 2010 | 1 comment
This issue has been solved. See solution.
hi,
i have configured local(LAN) VVR . The data (SQL DB)has relicating perfectly. i have planned to assign the drive letter for replicating (Readonly)volume, the main purpose is just coping the file to Local Disk ( form storge LUN to Server HDD)
whether it is possible ? any drawback is there?
discussion Filed Under:
Comments
Hi Alagesan, While you can
Hi Alagesan,
While you can mount a drive letter to the readonly volume on the VVR secondary with some windows and SFW versions, it is not recommended. When you mount the volume as readonly the master file table is read and cached in memory. VVR is still replicating and making changes to the volume that the cached copy of hte master file table does not reflect. The result is the data copied off the volume will be usable by SQL.
You should look at doing Flashsnap instead. It can be setup to do a snapshot to your local disk at the VVR secondary. When you want to use that data you initate a remote snapshot from the VVR primary. This will get the SQL database in the proper state to do the snapshot on the primary or secondary. Then VVR sends a request to the VVR secondary to snap off the snapshot copy and the SQL database and logs will be usable at that point. When you want to refresh the copy you simply resync the changes between the two volumes and do the remote snapshot process agan.
Thanks,
Wally
Would you like to reply?
Login or Register to post your comment.