Is it possible to make a web page that takes up responsibility for backing up a web applications tables(Oracle DB, and perhaps SQL server I am trying to be multi db supportive)? Essentially I want to create a database backup script that is kicked off by pressing a button on a web page. I have no idea what a dba backup script would look like. Ideally I would place the backup someplace secured, and I can impersonate accounts. I could also use a Quarts .NET cron job, the main hurdle is I don't know anything about DBA tools.
overwraith
83
Newbie Poster
Recommended Answers
Jump to PostI know stuff but if you won't make a post with a clear request along with details about the host, what script languages and servers (web, SQL, etc.) then who can offer a script you might be able to use?
Also, you may be done with me since our SQL …
Jump to PostAs to obstinate. "stubbornly refusing to change one's opinion or chosen course of action, despite attempts to persuade one to do so."
I had hoped you would restate your question along with necessary details so everyone can have a chance at helping you out.
My view here is you can …
Jump to PostBoth Oracle and SQL Server support
BACKUP DATABASE
, but they have different syntaxes and options.Providing you can connect a web app to any database you want to back up, you should be able to execute these commands using the SQL driver your language/framework provides.
All 12 Replies
rproffitt
2,580
"Nothing to see here."
Moderator
overwraith
83
Newbie Poster
rproffitt
2,580
"Nothing to see here."
Moderator
overwraith
83
Newbie Poster
rproffitt
2,580
"Nothing to see here."
Moderator
overwraith
83
Newbie Poster
rproffitt
2,580
"Nothing to see here."
Moderator
overwraith
83
Newbie Poster
rproffitt
2,580
"Nothing to see here."
Moderator
rproffitt
2,580
"Nothing to see here."
Moderator
pty
882
Posting Pro
rproffitt
commented:
Fine example about how details matter.
+12
overwraith
83
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.