Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
how to get database backup automatically

i want to have automatic backup in my 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?

share|improve this question

marked as duplicate by Shane Madden, Jason Berg, mailq, John Gardeniers, splattne Aug 29 '11 at 6:08

This question was marked as an exact duplicate of an existing question.

up vote 0 down vote accepted

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.

share|improve this answer
thanks for reply, but what is Windows 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. – M_Mogharrabi Aug 29 '11 at 5:21 - it might vary slightly across the different versions of Windows. – user48838 Aug 29 '11 at 6:04
thanks but i want to do it programmaticaly not by wizard. – M_Mogharrabi Aug 30 '11 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 '11 at 4:41

Not the answer you're looking for? Browse other questions tagged or ask your own question.