 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / March 2008Database backup from a web browser
Hi, Can I backup & restore my sql server database from aspx page located on a client machine ? Thank You. Sure you can . use BACKUP DATABASE sql statement.. Just remember do not connect to the DB you want to back up. Connect to master DB George. > Hi, > Can I backup & restore my sql server database from aspx page located on a > client machine ? > Thank You. Thank you for your reply. How can I implment this? > Sure you can . > [quoted text clipped - 9 lines] >> client machine ? >> Thank You. I am afraid you cant. If you asking this :) George. > Thank you for your reply. > How can I implment this? [quoted text clipped - 12 lines] >>> a client machine ? >>> Thank You. Sure I know how to backup and restore a db using sql server 2000 or 2005. Im asking about how can I provide a web form, using asp.net 2.0, to the client that can let him or her do the same task remotely? >I am afraid you cant. If you asking this :) > [quoted text clipped - 16 lines] >>>> a client machine ? >>>> Thank You. > Sure I know how to backup and restore a db using sql server 2000 or 2005. Im > asking about how can I provide a web form, using asp.net 2.0, to the client [quoted text clipped - 22 lines] > > - Show quoted text - take a look at my article at http://www.siccolo.com/Articles/CodeProject/Backup_Database_Web_Method/Web_Metho d_To_Backup_Database.html ... more at http://www.siccolo.com/articles.asp I am not sure what is your question? What exactly is your problem? "How do i write an application?" is not a question we can help with (except may be with the answer "hire a programmer") Can you make a web form that runs "UPDATE" or "SELECT" statement? If you can then just replace "UPDATE" with "BACKUP DATABASE" and change your connection string to connect to master database.... If you can not then you will need to go to http://asp.net/learn/ and learn how to make a web form... George. > Sure I know how to backup and restore a db using sql server 2000 or 2005. > Im asking about how can I provide a web form, using asp.net 2.0, to the [quoted text clipped - 20 lines] >>>>> on a client machine ? >>>>> Thank You. If I would hire a programmer, I will not hire such a rude person like you for sure. Don't help me again when I ask something else here. >I am not sure what is your question? What exactly is your problem? > "How do i write an application?" is not a question we can help with [quoted text clipped - 34 lines] >>>>>> on a client machine ? >>>>>> Thank You. Sorry that I was rude. I just tried to be truthful. More painful, but usually works better and faster than half measures. George. > If I would hire a programmer, I will not hire such a rude person like you > for sure. [quoted text clipped - 38 lines] >>>>>>> on a client machine ? >>>>>>> Thank You. > Sure I know how to backup and restore a db using sql server 2000 or 2005. Im > asking about how can I provide a web form, using asp.net 2.0, to the client [quoted text clipped - 20 lines] >>>>> a client machine ? >>>>> Thank You. In simplicity, you just create a web form with a button and catch click event. Then in event handler method, you use classes like SqlConnection, SqlCommand to execute sql statement. Your done!  SignatureThanks, Duy Lam Phuong
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.