Hey all,
I am looking for some input from you fine folks on the following scenario and ideas on how to provide a decent solution.
We currently have multiple arrays and in this scenario we have a SQL cluster at the primary site and a standalone SQL server at a remote facility. Data is hosted at both sites on V class arrays. We are using SQL in a mirror config for most of the SQL (Windows) instances from primary to remote location except for a large database instance that contains blog objects taking up 4+TB of data. The pipe is not very big and takes about 90 mins to replicate 1 TB of data via remote copy testing. So we are looking at setting up a remote copy sync to move the data to the remote site once a day which is within the SLA requirements. The problem that I am finding is that we need to present the replicated data to the remote server. So looking for a way to sync the volumes and export the data on the remote side and script it using CLI and a SQL maintenance plan.
I am thinking we could do the replication, create an rw virtual copy, then present the snap to the destination server. We would kick off the sync once a day and once the sync was complete we would do an updatevv on that presented volume.
Thoughts??? Easier way to complete? Ideas? I am fairly new to rcopy so any help is appreciated.
John