Solved

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

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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now