Solved

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

Posted on 2003-11-11
7
297 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
  • 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

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.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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…

680 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