backing up an asp database

[J. Frank Parnell]

hello, i dont know asp at all, but i have been asked to backup a web site
and database
that is used on a site which uses .aspx.

i dont need to do anything with it, just copy it and send it along to
someone who will.

i have allready got all the files off the site with ftp, is the database in
there? i dont really even know what i'm looking for, but i dont see any .mdb
or .sql right off the bat. I'm thinking it must be a server based db, but i
really dont know.

thanks,
j

 

[Curt_C [MVP]]

did none of the information posted in the asp.general group help?

 

[J. Frank Parnell]

did none of the information posted in the asp.general group help?

not really. it was suggested to get the .mdb thru a script, or thru http,
but as i say, there was no .mdb on there.

well, someone suggested this(below), but it looks to me as if it will just
dl an .mdb. I am really quite ignorant of asp. Can i just make an .asp
file with this code, run it, and then look for it in the site?

To script the download use XMLHTTP.

Const cURL = "http://your-domain/your-folder/your-database.mdb"
Const cXML = "C:\your-folder\your-database.mdb"
Fetch(cURL,cXML)

Function Fetch(xURL,xOUT)
'***
'* Fetch()
'*
'* Fetch a file over the Internet.
'***
On Error Resume Next
Err.Clear
Dim b
With CreateObject("Microsoft.XMLHTTP")
.Open "GET",xURL,False
.Send
b = .ResponseBody
If Err.Number <> 0 Or .Status <> 200 Then
Fetch = False
Exit Function
End If
End With
With CreateObject("ADODB.Stream")
.Type = 1
.Open
.Write b
.SaveToFile xOUT,2
End With
Fetch = Err.Number = 0
End Function

thanks,
J

 

[Tom B]

You, or someone else, is going to have to look through the aspx pages and
determine what your database is.

If it's access, then you probably got the .mdb file off there already.

If it's Sql, then you'll have to write a script that will back the database
up to files. Then download them.

Do you have a good relationship with your ISP? They could probably tell you
what you are paying for -- which should theoretically, tip you off to the
database type.

Tom B

 

[Bob Lehmann]

I am really quite ignorant of asp.

And, apparently of ASP.Net as well.

It's this simple. If it's a file based DB, such as Access, you can't
download it unless it's inside the web accessible folders, and you know the
path to the DB or have FTP access to the folder in which the DB is
contained. If it's server based, such as MSSQL, you can't get to it unless
you know the seerver name & admin login.

Your motives are suspicious despite your explanation in asp.general. There's
probably a reason your "(non-programming)client of a (graphic
designer)friend" doesn't have this information

Bob Lehmann

 

[Bob Lehmann]

It's amusing how you refer to it as "backing up".

Bob Lehmann

 

[J. Frank Parnell]

And, apparently of ASP.Net as well.

It's this simple. If it's a file based DB, such as Access, you can't
download it unless it's inside the web accessible folders, and you know
the
path to the DB or have FTP access to the folder in which the DB is
contained. If it's server based, such as MSSQL, you can't get to it unless
you know the seerver name & admin login.

which i have. are there tools such as the ones available for mysql
available for asp(.net)? I couldnt find them last time i googled.

 

[J. Frank Parnell]

It's amusing how you refer to it as "backing up".

back it up, copy it, download it, whatever tickles your pickle.