Hey Rod,<br><br><div><span class="gmail_quote">On 2/6/07, <b class="gmail_sendername">Rod Newcomb</b> &lt;<a href="mailto:rodn@dice.com">rodn@dice.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">









<div link="blue" vlink="purple" lang="EN-US">

<div>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">&nbsp;</span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Snapmirror to our offsite location (done using SMSQL)</span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Shut down SQL at our offsite location. (No Problem)</span></font></p></div></div></blockquote><div><br>This isn&#39;t really needed&nbsp; anymore, you can also attach without shutting, as meantioned earlier
<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div link="blue" vlink="purple" lang="EN-US"><div><p><font face="Arial" size="2">
<span style="font-size: 10pt; font-family: Arial;">Disconnect the LUN (Using SDCLI ?)</span></font></p></div></div></blockquote><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US"><div><p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Create a new flexclone from our Snapmirrored copy.&nbsp; (Lun
Create ?)</span></font></p></div></div></blockquote><div><br>Have a look at the &#39;lun clone&#39; command! <br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US"><div><p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Reconnect to the new Flexclone LUN (????)</span></font></p></div></div></blockquote><div>
<br>Use either sdcli or SMSQL for that. Probably SMSQL (SmSqkBi) is most suited<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US"><div><p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Start up SQL Services. (No problem)</span></font></p></div></div></blockquote><div><br>Which is offcourse only needed if you stopped them to begin with ;) 
<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div link="blue" vlink="purple" lang="EN-US"><div><p><font face="Arial" size="2">
<span style="font-size: 10pt; font-family: Arial;">I would like this process to run automatically every 24
hours.</span></font></p></div></div></blockquote><div><br>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)
<br><br>Hope this helps you on your way!<br><br>/Nils<br></div></div><br>-- <br>Simple guidelines to happiness:<br>Work like you don&#39;t need the money,<br>Love like your heart has never been broken and <br>Dance like no one can see you.