Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Nov 28 '10 at 6:51

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

1  
they don't have a DBA? –  Mitch Wheat Nov 28 '10 at 4:04

1 Answer 1

up vote 7 down vote accepted

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

http://msdn.microsoft.com/en-us/library/ms189237.aspx

share|improve this answer

Your Answer

 
discard

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.