You need to use this code to revive database into SQL server
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
<ol> <li class="li1"><div class="de1"> <span class="kw1">Non-public</span> <span class="kw1">Sub</span> BtnRestore_Click<span class="br0">(</span>sender <span class="kw1">As</span> <span class="kw2">Object</span>, e <span class="kw1">As</span> EventArgs<span class="br0">)</span> <span class="kw1">Handles</span> BtnRestore<span class="sy0">.</span><span class="me1">Click on</span> </div></li> <li class="li1"><div class="de1"> <span class="kw1">Attempt</span> </div></li> <li class="li1"><div class="de1"> <span class="kw1">Dim</span> database <span class="sy0">=</span> CmbDatabase <span class="sy0">.</span><span class="me1">Textual content</span> </div></li> <li class="li1"><div class="de1"> <span class="kw1">Dim</span> ServrnameRestore <span class="sy0">=</span> CmbServer <span class="sy0">.</span><span class="me1">Textual content</span> <span class="sy0">.</span><span class="me1">Trim</span> </div></li> <li class="li1"><div class="de1"> <span class="kw1">Dim</span> OpenFile1 <span class="kw1">As</span> <span class="kw1">New</span> OpenFileDialog </div></li> <li class="li1"><div class="de1"> <span class="kw1">Dim</span> Constr <span class="kw1">As</span> <span class="kw2">String</span> </div></li> <li class="li1"><div class="de1"> Constr <span class="sy0">=</span><span class="st0">"Knowledge Supply="</span> <span class="sy0">&</span> ServrnameRestore <span class="sy0">&</span><span class="st0">"; Preliminary Catalog=grasp; Built-in Safety=True"</span> </div></li> <li class="li1"><div class="de1"> <span class="co1">'Open connection</span> </div></li> <li class="li1"><div class="de1"> <span class="kw1">Dim</span> sqlcon <span class="kw1">As</span> SqlConnection</div></li> <li class="li1"><div class="de1"> <span class="kw1">Dim</span> cmd <span class="kw1">As</span> SqlCommand </div></li> <li class="li1"><div class="de1"> <span class="kw1">If</span> OpenFile1 <span class="sy0">.</span><span class="me1">ShowDialog</span> <span class="sy0">=</span> DialogResult<span class="sy0">.</span><span class="me1">OK</span> <span class="kw1">Then</span> </div></li> <li class="li1"><div class="de1"> sqlcon <span class="sy0">=</span> <span class="kw1">New</span> SqlConnection<span class="br0">(</span>Constr<span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> sqlcon<span class="sy0">.</span><span class="me1">Open</span><span class="br0">(</span><span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> <span class="co1">' OpenFileDialog1.ShowDialog()</span> </div></li> <li class="li1"><div class="de1"> filename_Restore <span class="sy0">=</span> OpenFile1 <span class="sy0">.</span><span class="me1">FileName</span> </div></li> <li class="li1"><div class="de1"> <span class="kw1">Dim</span> StrQuery2 <span class="sy0">=</span><span class="st0">"Restore Database "</span> <span class="sy0">&</span> database <span class="sy0">&</span><span class="st0">" from disk ='"</span> <span class="sy0">&</span> filename_Restore <span class="sy0">&</span><span class="st0">"' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5"</span> </div></li> <li class="li1"><div class="de1"> <span class="co1">'Excute question</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> cmd <span class="sy0">=</span> <span class="kw1">New</span> SqlCommand <span class="br0">(</span>Strquery2 ,sqlcon<span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> cmd<span class="sy0">.</span><span class="me1">ExecuteNonQuery</span> <span class="br0">(</span><span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> MessageBox <span class="sy0">.</span><span class="me1">Present</span> <span class="br0">(</span><span class="st0">"Database "</span> <span class="sy0">&</span> database <span class="sy0">&</span> <span class="st0">" has been restored successfull"</span>,<span class="st0">"Message"</span>, MessageBoxButtons <span class="sy0">.</span><span class="me1">OK</span>, MessageBoxIcon <span class="sy0">.</span><span class="me1">Data</span> <span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> sqlcon<span class="sy0">.</span><a href="https://www.google.com/search?q=CLOSE+site:msdn.microsoft.com" rel="nofollow"><span class="kw7">Close</span></a> <span class="br0">(</span><span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> <span class="kw1">Else</span> </div></li> <li class="li1"><div class="de1"> <a href="https://www.google.com/search?q=MSGBOX+site:msdn.microsoft.com" rel="nofollow"><span class="kw7">MsgBox</span></a> <span class="br0">(</span><span class="st0">"Cancel"</span>,MsgBoxStyle<span class="sy0">.</span><span class="me1">Data</span> ,<span class="st0">"Cancel"</span><span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> <span class="kw1">Finish</span> <span class="kw1">If</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> <span class="kw1">Catch</span> ex <span class="kw1">As</span> Exception</div></li> <li class="li1"><div class="de1"> MessageBox <span class="sy0">.</span><span class="me1">Present</span> <span class="br0">(</span>ex<span class="sy0">.</span><span class="me1">Message</span> ,<span class="st0">"Message"</span>, MessageBoxButtons <span class="sy0">.</span><span class="me1">OK</span> , MessageBoxIcon <span class="sy0">.</span><span class="me1">Warning</span> <span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> <span class="kw1">Finish</span> <span class="kw1">Attempt</span> </div></li> <li class="li1"><div class="de1"> <span class="kw1">Finish</span> <span class="kw1">sub</span> </div></li> </ol> |
Thanks comply with Instagram: hassan_hambe
