Hey Rod,
On 2/6/07, Rod Newcomb rodn@dice.com wrote:
Snapmirror to our offsite location (done using SMSQL)
Shut down SQL at our offsite location. (No Problem)
This isn't really needed anymore, you can also attach without shutting, as meantioned earlier
Disconnect the LUN (Using SDCLI ?)
Create a new flexclone from our Snapmirrored copy. (Lun Create ?)
Have a look at the 'lun clone' command!
Reconnect to the new Flexclone LUN (????)
Use either sdcli or SMSQL for that. Probably SMSQL (SmSqkBi) is most suited
Start up SQL Services. (No problem)
Which is offcourse only needed if you stopped them to begin with ;)
I would like this process to run automatically every 24 hours.
You can run it from a script (NT Scheduler) on your active DB server to fire off SMSQL with SnapMirror, then use rsh for the lun clone / lun split commands and remotely mount the lun using SDCLI (maybe the last part can also be done with SMSQL, havent tried)
Hope this helps you on your way!
/Nils