Task Scheduler

Is it possible to use the task scheduler to do a database backup?

Thank you,

 

It is possible, see this thread (#5) for sample code: http://community.discountasp.net/showthread.php?t=7780

The sample project is a web page that uses the CP API web service and it supports compressing the backup on web server. Feel free to use the code as is or change it as you need to.

 

slq 2008 only

So I'm seeing that this only works with sql server 2008, is that coreect?

Thank you,

 

Bruce is correct, the CP API web service does support methods for backing up all SQL Server database versions supported by DASP but the sample code I referred to only supports SQL Server 2008 in its current form (because that's all I needed at the time).

The changes required to make it support the other versions would be trivial. It would be a one line change if you only have one SQL 2005 or SQL 2000 db. If you wanted to you could get a little bit more clever if you needed to backup multiple databases or wanted to make the operation configurable via the web.config

 

Help with backup process

Would someone be willing to help me to get the backup project in place and working with an sql server 2005 db? I don't have much experience with web services, but would like to learn through a current need like this.

Thank you in advance.