Help scheduling automatic backups of my SQL Server 2005 database

Discussion in 'Databases' started by grgrosso, Dec 17, 2008.

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

    grgrosso

    Hi all, does anyone know how to schedule an automatic backup of a DASP database?I have read that some DBAs create a batch file to do this, and then schedule it to automatically run somehow, but I am not sure how to do this with my DASP database. I can see that there is a tool called Scheduled Task Manager, and it looks like this tool could be used to do this, but I am not sure how to get to do it and would appreciate some help with setting this up.

    Thanks in advance.

    - George

    Post Edited (opcode901) : 12/17/2008 4:53:25 PM GMT
     
    grgrosso, Dec 17, 2008
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    George,

    we backup your database on a nightly basis and if you want us to pull those backup there will be a $15 charge.

    You can use the Adhoc backup tool in the control panel to create your database backup BUT you cannot schedule it.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Dec 17, 2008
    #2
  3. grgrosso

    grgrosso

    Thanks Bruce. I read in the Scheduled Task Manager help file that I could do database maintenance, so while I cannot perform automatic backups, can I set the Scheduled Task Manager to run one of my stored procedures on my database? If not, then what sort of maintenance can I do, and how?


    - George
     
    grgrosso, Dec 17, 2008
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    basically, the scheduled task tool makes a HTTP call to the page you specified at a specific time. You can pretty much create an ASPX page that can do anything you want w/ the database. You cannot perform database backup because you cannot issue a backup command.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Dec 17, 2008
    #4
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