Shared windows hosting - Database automate backup

Hello,

We have an website hosted in a shared windows account and provided with panel, ftp and database access(DB is located in another server). Right now we are trying to automate the database every day and we don't find a way to do it. And also we can see that there is a tool to take backup through the control panel, which is a manual backup process, is it possible to automate the same process or Is there any other way to automate database in a shared windows hosting? ?

waiting for the replies !!! Thanks in advance !

Thanks,
Ephronlakshman

 

Hi,
The API that is provided:
http://api.discountasp.net/1.0/customerapi.asmx

 

Thanks for responding

Could see an API "Sql2008CreateBackup" which may help my requirement. But have no idea how to use it from my end in a proper procedure . How to use these API from my end , any proper procedure for it, so that I can get some ideas !!!

Thanks in Advance

 

See this sticky thread: http://community.discountasp.net/showthread.php?t=7780. Post #5 includes a link to some sample code that's still hosted on my website that I wrote in Q1 2009. If you take a look you'll see it's a simple little web application that uses the DASP control panel API web service to perform a database backup. It's pretty well documented in the thread and the prior post #5 links to. The zip file contains a readme.txt too.

Hopefully this might give you some ideas but keep in mind this sample code is implemented as a web application that calls the API web service and it was originally written with the intention it would be hosted on the DASP web server and the db backup automated using the DASP scheduler. In fact that's the way I still to this day have it setup on the DASP server.

It's entirely possible to call the DASP control API web service over the internet too if that's what you need.

 

Hi Joe,
Can i make it work with "Sql2005CreateBackup" also? or do you have any scripts to automate MSSQL 2005 database backup seperately?

Any help would be greatly appreciated..

thanks,

Santhosh

 

Sure you can make it work however you like because full source code is downloadable. The sample code provided does only support MSSQL2008 but the change to make it support MSSQL2005 via the DASP control panel API would be fairly trivial.

 

Thanks for the reply joe..will try to get it work with mssql2005 and get back to you if any problems