I just wanted to mention that I created an application for performing automatic backups of a DiscountASP.NET MSSQL database. This application can be installed as a Windows Service and ran in the background without any user interface. If ran as a service, every day at 12:00AM the application will use the DiscountASP.NET Control Panel API to perform a MSSQL database backup, download and rename the backup file, and optionally purge any old backups. This application can also be ran from the Command Prompt or setup as a Task in the Windows Task Scheduler. It includes the ability to optionally send an email with a summary of the results. Note, all events (success, failures, and errors) are logged in the Windows Application Event Log with a Source of DASP SQL Backup. I originally blogged about this in May 2011 at http://www.pfsolutions-mi.com/blog/2011/05/05/DiscountASPNETSQLBackupV0100.aspx I updated the application in December 2011 and blogged about running it as a Task at http://www.pfsolutions-mi.com/blog/2011/12/04/DiscountASPNETSQLBackupV1000.aspx
I updated my website... Blog Articles http://pfsolutions-mi.com/blog/category/DSB.aspx Downloads http://pfsolutions-mi.com/Product/DASPSQLBackup
Critical Update for the DiscountASP.NET SQL Backup application. Read about it on my Blog at http://pfsolutions-mi.com/blog/category/dsb.aspx. Download update from http://pfsolutions-mi.com/Product/DASPSQLBackup
Do you have the source code? I followed this link but couldn't find the download. Is there someway I can get the source code? I'm currently using an API call viz. api.Sql2005CreateBackupAsync but it doesn't work on SQL 2012 database. Any help will be greatly appreciated. Thanks!
Hi BusyCoder, did you try clicking the red download image on the bottom of the page? Are you using a custom API? The DASP SQL Backup utility I wrote supports the Sql2000CreateBackup through Sql2012CreateBackup methods. I don't see a Sql2005CreateBackupAsync method in the documentation.
Got the exe but there's no source Hi Frank, didn't realize that image was actually for download I managed to download the exe but there's no source code. I'm assuming you don't want to share the source? The only thing I need is the three lines where you invoke the API call. I was using the class CustomerApi which didn't have an option to make the 2012 call. I could see one for 2000 and one for 2005. But that method gives me a "cannot find database by that name" error. I stumbled across documentation for CustomerAPI 1.6. But that may be pretty old. Is there a link to get the latest API documentation? Thanks!
Frank, please ignore my previous message. I manually modified a proxy class. I had to get rid of the 2005 backup calls and change them to 2012 method calls. It has worked. The call was made but I got an error that the file already exists. But that's a different problem. Thanks for your help!
Hi BusyCoder, I thought that you were having trouble using the utility I wrote. But it sounds like you are writing your own solution. If so, just a heads up that the API doesn't support compressing the backups like the Web UI does. And you are probably getting the file already exists message because a previous backup already exists in the destination. Also keep in mind that the API has a limitation of performing a backup once every 6 hours.
Thanks, Frank. You're right, I found it the hard way. Only one hit every six hours. But that's cool. And there was already a file in that location which I subsequently deleted. Should be smooth sailing from here on, I hope. Originally, I though I'd use your Windows service, but I would've loved to have the source code.
