-1

Possible Duplicate:
how to get database backup automatically

i want to have automatic backup in my program.it means that for example every 30 minutes a table that contains backup schedules should be checked and get backup from my db if the special time in the schedule is passed.this backup code should work even if the program is not running,means that it should starts when the windows loads and stops when the windows shuts down. now i want to know what is the best way for this? can windows service do this for me?

0

1 Answer 1

0

You can write it as a service or just call it from the Windows Scheduler. Either approach will work, with the possible advantage going to the scheduler route as the scheduling is also taken care of with that approach.

4
  • thanks for reply, but what is Windows Scheduler.by the way i used windows service but i need to use Timer control in it to check the backup schedule table every 30 minutes but it does not work in windows service. Aug 29, 2011 at 5:21
  • iopus.com/guides/winscheduler.htm - it might vary slightly across the different versions of Windows.
    – user48838
    Aug 29, 2011 at 6:04
  • thanks but i want to do it programmaticaly not by wizard. Aug 30, 2011 at 4:16
  • The wizard is strictly for the scheduling of a task, which in this case is something you would program (the actual backup task).
    – user48838
    Aug 30, 2011 at 4:41

Not the answer you're looking for? Browse other questions tagged .