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

My client would like to have the database backed up several times per day, as well as the ability to backup the database manually.

I've created a page to backup the database manually, it just calls a stored procedure that backs up the database.

But I'm having trouble with having the database backup at certain intervals, say noon and midnight. I thought about setting up the server to hit my manual backup page at certain intervals, but I didn't know if SQL Server has something built in that would do backups at specific times.

I'm using ASP.NET 4.0 and SQL Server 2008.

share|improve this question

migrated from Nov 28 '10 at 6:51

This question came from our site for professional and enthusiast programmers.

they don't have a DBA? – Mitch Wheat Nov 28 '10 at 4:04
up vote 7 down vote accepted

Use SQL Server Agent to schedule the stored procedure that you call to make the backups.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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