Hi I'm looking to automat a backup of my SQL server database (2008 express). I would like to do this daily prior to running some other scheduled jobs.Having not created backup schedules befor I was looking for a bit of advice and assistance/examples.
1) What is the best way to get a scheduled back up. Is this through SQL server or create a script and get windows scheduler to run the script (if possible) are there other alternatives.
2) when I perform a backup I would like to keep the past 20 backups. I see that you can set up backups to expire after a certain amount of time. So do I append to an existing backup or do I create a backup with a datestamp - how would I do either?
3) what other things may I need to take into consideration ?
Appologies for this being very general however I have not had much experience here.