Creating database backup from ASP page

Question

One of my client has ASP site. Now he want to transfer the site to a different hosting. Unfortunately I have only FTP of the live site. Could any one please advise about how to create database backup using ASP pages.

What kind of DB you use? Don't you have any ways to access the DB? Or even to ask the hosting to provide an export or backup of the DB? — ppeterka
– ppeterka, Commented Sep 11, 2013 at 7:47

Vogel612 · Accepted Answer · 2013-09-11 13:58:47Z

1

Well in the worst case you could always do the Brute Force create new Backup on-click method:

<%Dim SQL, Conn, Database
Database = //Your database-Path
set conn = Server.CreateObject("ADODB.Connection")
conn.Open("/*Connection-String*/" + Database, 3,1)

SQL = "CREATE DATABASE [BackupDB]; BACKUP [Database] TO [BackupDB];"
conn.Execute(SQL)
%>
Database was backed up to "BackupDB"

but that should be avoided at all cost, because it is very unsafe and might as well shut down your whole system, if done wrong...

Best would be as @ppeterka 66 mentioned, that you ask your hosting provider to backup your database and send it to you.

answered Sep 11, 2013 at 13:58

Vogel612

5,6535 gold badges54 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating database backup from ASP page

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related