Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2003-11-11
7
Medium Priority
?
300 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 2000 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

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

670 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