4

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.

1
  • 1
    they don't have a DBA? Nov 28, 2010 at 4:04

1 Answer 1

7

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

You must log in to answer this question.

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