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.