473,320 Members | 1,920 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.

Run ASP without client visit? Automating backup and status check?

I know ASP isn't the best way to do this, but is it possible???

I've written an application in ASP that manipulates an MS SQL database. We'd
like to have our application automatically backup the database at specific
times. We'd also like to generate an email report once a day on the statics
of our database.

Is this possible with ASP? How else could it be done, considering our
application is all HTML/ASP?

Thanks for any input!!!
Feb 6 '06 #1
4 1248
Noozer wrote on 06 feb 2006 in microsoft.public.inetserver.asp.general:
I've written an application in ASP that manipulates an MS SQL
database. We'd like to have our application automatically backup the
database at specific times. We'd also like to generate an email report
once a day on the statics of our database.

Is this possible with ASP? How else could it be done, considering our
application is all HTML/ASP?


Do a GET from a scheduled Cscript:
With CreateObject("MSXML2.XMLHTTP")
.open "GET", "http://tst.com/doit.asp", True
.send
End With


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Feb 6 '06 #2
Defined as a server side task (and as a VBS script for exemple).

You should also be able to find sites that are able to call your url at
given times (basically a kind of "webcron") if you don't have access to the
server.

--
Patrice

"Noozer" <do*******@me.here> a écrit dans le message de
news:VOIFf.454300$2k.178388@pd7tw1no...
I know ASP isn't the best way to do this, but is it possible???

I've written an application in ASP that manipulates an MS SQL database. We'd like to have our application automatically backup the database at specific
times. We'd also like to generate an email report once a day on the statics of our database.

Is this possible with ASP? How else could it be done, considering our
application is all HTML/ASP?

Thanks for any input!!!

Feb 6 '06 #3
You could use script in a Scheduled task.

The script could use the MSXML2.ServerXMLHTTP object to post to the website
to trigger off activity.

Anthony.
Feb 6 '06 #4
1. Create your "all-in-one" backup script

2. Use this: http://www.webcron.org/ to call this scripts at regular
intervals.

Enjoy ;)

Phil

Noozer wrote:
I know ASP isn't the best way to do this, but is it possible???

I've written an application in ASP that manipulates an MS SQL database. We'd
like to have our application automatically backup the database at specific
times. We'd also like to generate an email report once a day on the statics
of our database.

Is this possible with ASP? How else could it be done, considering our
application is all HTML/ASP?

Thanks for any input!!!


Mar 1 '06 #5

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

Similar topics

1
by: eddie wang | last post by:
Hello, I am running SQl Server 7.0. I have a database maintenance plan that runs once a day to perform backups. It seemed that the database backup files were created successfully. The problem...
3
by: Colin Finck | last post by:
Hello! I need to backup a MySQL database (MySQL 4.0). But it is on a shared-hosting web server and so I don't have direct server access. I also have no phpMyAdmin installed. How can I backup the...
4
by: nielsonj1976 | last post by:
I am getting a failure on the db backup job of one of my maintenance plans. It is coming back with the generic error message of, "sqlmaint.exe failed. (Error 22029). The step failed." 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...
6
by: Gladiator | last post by:
Hai every one... I was trying List history backup cmd.......... the output i got is List History File for first Number of matching file entries = 12
1
by: Divakar | last post by:
Hi, When I do a LIST HISTORY BACKUP, the following is shown the O/P. ---------------------------------------------------------------------------- Comment: DB2 BACKUP ABCD ONLINE Start Time:...
2
by: m19peters | last post by:
We have a script that I had to rework a little bit for 2005 that does a full backup for every database on the server... For some reason on some nights the script does not backup all databases......
0
by: glubber | last post by:
I have a cronned perl script that runs on a different server. when I try to restore it to the server below things dont copy across correctly. the target server is described below. debian 4.0...
3
by: aj | last post by:
SQL Server 2005 SP2 Using SSMS, I've just backed up my transaction log (which is around 314 megs) on a smallish database. I purposely generated a bunch of dummy transactions to grow the trans...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.