This entry explains how I set-up my Web Server to back-up my SQL database.
Open up SQL Server Enterprise Manager
Select a server group
From the top menu select tools>backup database
Select the database you want to backup
Select the type of backup
I usually set-up two backups
Complete once a week
You must add a destination. I use a file as a destination on a folder designated for my database backups.
Schedule the backup
Again Complete once a week
You may get a warning message SQLServerAgent on target server ‘(local)’ is stopped.
Go to services by
Right click My Computer and click manage
Open up the Services and Applications tree
Find the SQLServerAgent
Right click this service and go to properties
Change startup type to Automatic (this will make sure the service is running anytime the server is rebooted
Also start the service.
If you need to make changes to these settings you can find these backup routines in SQL Server Enterprise Manager by opening Management>SQL Server Agent > jobs, you may need to refresh if you have just added the job.