I have posted a query before and solved the problem myself. What I am doing is using the filesystem object to copy my Access DB to another folder on my site for a backup. I then have a page that says when the backup DB was created, uses the filesystem object as well. My question is that when I backup the DB the page does not display the correct time and date of when the DB was last backed up. Here is my process for backing up the DB:
First I Delete a previous backup and lock the current DB
Then I copy the current DB to replace the copy I deleted
Then I un-lock the DB and return the user to the page that should show the correct date and time.
I have created ASP application which is on one server. This application uses Access database. Is there some possibility to create an ASP script that will copy my MDB database on some other server?
Web site type: mdb driven shopping cart.ALtho my web host peforms nightly backups, I wish to create one of my own.I intend to do the following:
create a scedule in cuteftp to dload an mdb file nightly.My concern is,that during the dload what happens if someone is reading/writing to the mdb whilst using the website? Could this corrupt the mdb,or would the site throw an error during the mdb dload period?
I uploaded all the files to the website. I am using Access database.Everyday i want to take backup. How can i take backup from ASP and copy to my local system. If any problem in the database i will restore the backUp file.I am using classic ASP. I want to compress the database and backup.
I'm coming to the conclusion it isn't possible, because I can't find any reference to it anywhere on the web after a good deal of searching. Let me explain my position, I'm writing an admin area which will access and update a large MySQL database. When the asp code runs the update (about once a week), there will be a high potential for things to go wrong, and as a precautionary measure I wanted to perform a database backup before it ran the database updates. What I wanted to do was similar to the PHPMYADMIN "Export" function, but in ASP, and save the file on the server for me to download at a later date if needed. If I could create the file, I figured that I could save it to a directory with write priveledges on the server using FSO. The problem is actually creating a dump of the structure of all of the tables using an ASP script. I have no idea how PHPMYADMIN manages to do it, but I don't know any PHP whatsoever, and I would far prefer to make it work automatically through the admin area I am scripting in ASP. All the references I could find in the MySQL manual were to creating the backup using telnet access, which we don't have at my host for security reasons, so I wondered if anyone else had come accross this problem before and had a possible solution that could help me [], or whether anyone can say that it definitely is not possible.
As the subject states, does anyone know how I can backup an Access db, using ASP ? Is there a 'copy' statement or similar?Ideally, some method to ensure no one else is logged on, then copy the file from the "physical" path, like retrieving:
request.servervariables("APPL_PHYSICAL_PATH")
for the Access db, then copy the entire db to a sub folder called "/db/backup" . I want to do this remotely, not locally, because there is a lot of testing to do in the next few weeks, and I don't want to have to upload the (good) copy of the Access db evertime some additional changes to the db are to be made. I would like to save the bandwidth.
I would like to backup the Remote Access database from a link on my asp application . Is it possible ?For instance, there would be a menu which once clicked will initiate login/password and ftp server, get the database and rename it with currentdate, close the connexion ?
I am looking for a script that can take my Access DB and make a copy of it and store it in another folder. Does anyone know where I can get a code or script to do this?
im facing some troubles with a sql server database running on windows server . the problem is i need to backup my database coz i ve lost the local copy of it and i cannot also connect to it via enterprize manager (but it's working good with my site on the serer) .
so i need to create some asp script that reads the names of the tables of this database and also gets the structure of them (fields names and data type of each table) so i can use this data to re-build the database on my local machine .
I have one SQL server 2000 backup file,now i want to restore that file using ASP.How can i do this please give me the solution for that .Is there any way for that.
I have been searching for a script that when i click on backup in the admin section of the site it will backup the database in a backup folder with a datestamp but cant finde it. I dont really know with the backup procedure but a good backup script.
Is it possible to backup a Database from one domain to another using the File System Object? I want to save a DB from a folder on my1stsite.com to my2ndsite.com but obviously the server.mappath won't work and putting the URL of the folder to save to doesn't either i.e. http://www.my2ndsite.com/savefolder/myDB.mdb .
I have set up a new server and now I try to move all the web ASP files, scripts to my new server.
I do copy and paste all the files to my webroot directory. None of the page works, the browser simplely redirect me to the search engine page. I have about total 50 ASP scripts and files. None of them shows after I entered the address in the browser. No bug and no syntex errors.
If I created a very simple ASP page like "Hello world", it works fine. Then even the Hello world page stopped working after I copy and paste any parts of the code from my backup CD.
I also heard someone mentioned about domain name hard coded program, could it possible in my case?