I am looking for some help.
We have two MS SQL servers. One is running in production, and we are snapmirroring the data over to an offsite location.
Since Snapmirrors are read only, we would like to use Flexclone to create a writeable copy of this LUN for our off-site SQL server to use.
We also have SnapDrive and Snap Managager/SQL software available to us.
The trick is that I would like to automate the following process:
Snapmirror to our offsite location (done using SMSQL)
Shut down SQL at our offsite location. (No Problem)
Disconnect the LUN (Using SDCLI ?)
Create a new flexclone from our Snapmirrored copy. (Lun Create ?)
Reconnect to the new Flexclone LUN (????)
Start up SQL Services. (No problem)
I would like this process to run automatically every 24 hours.
Does anyone have any scripts or suggestions on how I can do this?
Rod Newcomb