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

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..).  
dynaworxAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arbertCommented:
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
dynaworxAuthor Commented:
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.
arbertCommented:
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.
dynaworxAuthor Commented:
well I guess I am looking for someone to code that for me and provide a means to integrate it into this tool.
arbertCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.