Solved

Backup/Restore Addition to Microsft .NET Web Data Administrator Application

Posted on 2003-11-11
7
298 Views
Last Modified: 2012-06-22
Currently, the Microsoft Web Data Administrator application (does not support Backup and Restore Features for DBs. I would like to extend the interface to include this as a content menu option. After Login, the DBA should be able to select one of their DBs and perform a backup, and then be able to download that backup.  Alternatively, they should be able to upload a backup and restore that.  The backup directory would be set to a UNC path \\server\dbbackup which is the default MS backup dir (i.e. - c:\program files\microsoft sql\data\backup or whereever sql 2000 has been installed).  There should be settings foe maximum size of file upload/download, and of course all the available options for backup and restore that you see in enterprise manager such as what kind of backup to perform (complete, transactions, etc..) and what kind of restore to perform (force, transaction, etc..).  
0
Comment
Question by:dynaworx
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 9727296
I think you're trying to reinvent the wheel.  Why isn't enterprise manager available?

Quite honestly, I'm betting the backup/restore options aren't available in the "web application" because backup and restore functions aren't something that should be trusted across the net.  It wouldn't be a bad idea to initiate the backups, but to trust the data to download/upload across the net is another thing....

What you want to do would not be that difficult with .Net (or VB if you don't want a web app), you simply would execute a "backup database" or "restore database" command against a connection object.

Brett
0
 

Author Comment

by:dynaworx
ID: 9727856
I run a shared hosting environment and Enterprise Manager Access is not something I want to entertain for obvious security reasons.  The only real way to do that properly anyway is to set up a windows 2003 terminal server in application mode locked down with group policy but allow drive mappings to the user's db backup folder.  This would comsume a machine so it is not really a good solution.  It also has session limitations. A web application that does 90% of what these folks are doing anyway is a much better solution in a shared environment as it is far more secure and way more scaleable.  Yes it is doable which is why I posted here in the first place to see if anyone was up for the challenge.  That is really all that application is missing i in my mind for what I need it to do.
0
 
LVL 34

Expert Comment

by:arbert
ID: 9728434
I understand everything you say above.

Like I said, it would be simple to code the functionality using simple connection (with .NET) to the database and BACKUP DATABASE/RESTORE DATABASE commands.

This extra functionality you want to add sounds nice--not something you usually find from a hosting company--they offer you the pre-scheduled backups and that's it.
0
 

Author Comment

by:dynaworx
ID: 9728583
well I guess I am looking for someone to code that for me and provide a means to integrate it into this tool.
0
 
LVL 34

Accepted Solution

by:
arbert earned 500 total points
ID: 9736493
This site really isn't so much about providing coding services--it's about providing answers.

If you really want a coder to supply you personalized coding services, take a look at http://www.planetsourcecode.com
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question