473,320 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Database backup from a web browser

Hi,
Can I backup & restore my sql server database from aspx page located on a
client machine ?
Thank You.
Mar 11 '08 #1
8 1385
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.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:OG**************@TK2MSFTNGP05.phx.gbl...
Hi,
Can I backup & restore my sql server database from aspx page located on a
client machine ?
Thank You.

Mar 11 '08 #2
Thank you for your reply.
How can I implment this?

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:u9**************@TK2MSFTNGP03.phx.gbl...
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.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:OG**************@TK2MSFTNGP05.phx.gbl...
>Hi,
Can I backup & restore my sql server database from aspx page located on a
client machine ?
Thank You.


Mar 11 '08 #3
I am afraid you cant. If you asking this :)

George.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:uh**************@TK2MSFTNGP05.phx.gbl...
Thank you for your reply.
How can I implment this?

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:u9**************@TK2MSFTNGP03.phx.gbl...
>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.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:OG**************@TK2MSFTNGP05.phx.gbl...
>>Hi,
Can I backup & restore my sql server database from aspx page located on
a client machine ?
Thank You.



Mar 11 '08 #4
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?

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:eN**************@TK2MSFTNGP05.phx.gbl...
>I am afraid you cant. If you asking this :)

George.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:uh**************@TK2MSFTNGP05.phx.gbl...
>Thank you for your reply.
How can I implment this?

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:u9**************@TK2MSFTNGP03.phx.gbl...
>>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.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:OG**************@TK2MSFTNGP05.phx.gbl...
Hi,
Can I backup & restore my sql server database from aspx page located on
a client machine ?
Thank You.



Mar 11 '08 #5
On Mar 11, 10:53*am, "Tamer Ibrahim" <t.ge...@gmail.comwrote:
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?

"George Ter-Saakov" <gt-...@cardone.comwrote in message

news:eN**************@TK2MSFTNGP05.phx.gbl...
I am afraid you cant. If you asking this :)
George.
"Tamer Ibrahim" <t.ge...@gmail.comwrote in message
news:uh**************@TK2MSFTNGP05.phx.gbl...
Thank you for your reply.
How can I implment this?
"George Ter-Saakov" <gt-...@cardone.comwrote in message
news:u9**************@TK2MSFTNGP03.phx.gbl...
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.
>"Tamer Ibrahim" <t.ge...@gmail.comwrote in message
news:OG**************@TK2MSFTNGP05.phx.gbl...
Hi,
Can I backup & restore my sql server database from aspx page located on
a client machine ?
Thank You.- Hide quoted text -

- Show quoted text -
take a look at my article at
http://www.siccolo.com/Articles/Code..._Database.html
... more at http://www.siccolo.com/articles.asp
Mar 11 '08 #6
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.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:Oh**************@TK2MSFTNGP02.phx.gbl...
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?

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:eN**************@TK2MSFTNGP05.phx.gbl...
>>I am afraid you cant. If you asking this :)

George.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:uh**************@TK2MSFTNGP05.phx.gbl...
>>Thank you for your reply.
How can I implment this?

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:u9**************@TK2MSFTNGP03.phx.gbl...
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.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:OG**************@TK2MSFTNGP05.phx.gbl...
Hi,
Can I backup & restore my sql server database from aspx page located
on a client machine ?
Thank You.
>




Mar 11 '08 #7
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.

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:Oi**************@TK2MSFTNGP06.phx.gbl...
>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.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:Oh**************@TK2MSFTNGP02.phx.gbl...
>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?

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:eN**************@TK2MSFTNGP05.phx.gbl...
>>>I am afraid you cant. If you asking this :)

George.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:uh**************@TK2MSFTNGP05.phx.gbl...
Thank you for your reply.
How can I implment this?

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:u9**************@TK2MSFTNGP03.phx.gbl...
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.
>
>
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:OG**************@TK2MSFTNGP05.phx.gbl.. .
>Hi,
>Can I backup & restore my sql server database from aspx page located
>on a client machine ?
>Thank You.
>>
>
>




Mar 11 '08 #8
Sorry that I was rude. I just tried to be truthful.
More painful, but usually works better and faster than half measures.

George.

"msnews.microsoft.com" <t.*****@gmail.comwrote in message
news:OY**************@TK2MSFTNGP04.phx.gbl...
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.

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:Oi**************@TK2MSFTNGP06.phx.gbl...
>>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.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:Oh**************@TK2MSFTNGP02.phx.gbl...
>>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?

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:eN**************@TK2MSFTNGP05.phx.gbl...
I am afraid you cant. If you asking this :)

George.
"Tamer Ibrahim" <t.*****@gmail.comwrote in message
news:uh**************@TK2MSFTNGP05.phx.gbl...
Thank you for your reply.
How can I implment this?
>
"George Ter-Saakov" <gt****@cardone.comwrote in message
news:u9**************@TK2MSFTNGP03.phx.gbl.. .
>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.
>>
>>
>"Tamer Ibrahim" <t.*****@gmail.comwrote in message
>news:OG**************@TK2MSFTNGP05.phx.gbl. ..
>>Hi,
>>Can I backup & restore my sql server database from aspx page located
>>on a client machine ?
>>Thank You.
>>>
>>
>>
>
>




Mar 11 '08 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Rajesh Garg | last post by:
I will make it simpler to look... I have DB1 - as backup for day 1 LOg1 as backup of logs T1 T2 T3 T4 T5 ...some transaction on day 2 Now i backup again DB2 Log2
6
by: Edwinah63 | last post by:
Hi Gurus, i am having problems with restoring a ms sql database. i have restored the database using veritas to a different location ('g:\datafiles') in no recover mode. when i view the...
2
by: trotter | last post by:
I want to know if there is a "best-practice" for setting up Database Maintenance Plans in SQL Server 7 or 2000. To be more specific, I want to know the order in which I complete the tasks. Do I...
2
by: Matt | last post by:
I run SQL Server 2000 and use thier database maintenance plans to backup my databases. My questions is what happens if a change is being made to a database table while a backup is running? Should I...
6
by: Richard Hollenbeck | last post by:
I'd like a button on my main form to backup the database. How can I call up the Windows folder browser to prompt me for a filename and type (*.mdb) and folder to save in? I looked in my book and...
5
by: HSP | last post by:
hi. i need to restore an old database. The db was backed up using a DLT drive, using 2 volumes. The content for the tapes was copied to file onto Solaris machine using rsh and dd (for backup...
3
by: Big Charles | last post by:
Hi, We have developed an ASP.NET web application and are planning to host it in an external Server, which provides us a good bandwidht. We need to put he web application outside because the...
18
by: NDayave | last post by:
ive managed to piece together this code that creates a backup folder and then copies the (Access 2000) database into it under the new name "Backup YYYY-MMM-DD HH.MM". It worked fine in the...
5
by: Steve | last post by:
Hi; I thought I would rephrase a question I asked in another post to more quickly get to the heart of the matter. My apologies for anyone who is offended by what appears to be a repetition. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.