SQL Server

Discussion in 'Pre-sales questions' started by MushroomBill, May 26, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. MushroomBill

    MushroomBill Guest

    Two quick questions...

    1) Would you perform regular backups of the database on my behalf or is there some method for me to achieve this?

    2) Can I run regular scheduled jobs on the database? (i.e. once an hour I'd want to run a procedure to send some emails)

    Thanks!
     
    MushroomBill, May 26, 2010
    #1
  2. dmitri

    dmitri DiscountASP.NET Staff

    We cannot run scheduled backups of your database. You will need to backup your database on the server by logging in to your control panel and using web based SQL Tools.

    Scheduling, automation, and monitoring are not allowed on our production SQL Servers for the security reason, thus you cannot create and run scheduled jobs. Emailing capabilities are also disabled on our servers for the same security reason.
     
    dmitri, May 26, 2010
    #2
  3. CrystalCMS

    CrystalCMS Joe

    I've enabled automated daily scheduled SQL Server backup with zip support on the DASP servers. The method I developed uses the DASP scheduler and the control panel API to perform regular backups without user intervention. So it's not the traditional SQL Server Agent type job you might perform elsewhere but the result is basically the same.

    It's also possible to use the DASP scheduler to perform other maintenance type operations and automated tasks like emailing. These types of scheduled tasks do need to be performed in web server code (e.g. aspx code behind) rather than in the database, but the possibilities are very flexible.

    Edit: See the sticky post with the title '2008 backup compression' at the top of the DiscountASP.NET API forum for details of the automated backup application. There's also a link to download the code in there.
     
    CrystalCMS, May 26, 2010
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page