how do i automatically back up my sql server database every month?

Question

i have a sql server 2005 database without around 100 tables. i need to back it up every month. is there a way to automate this process? how would i do it? i am a newbie so please explain thoroughly

if it is a stored procedure please let me know what that procedure would look like and where to call it from.

Answer 1

you could create a maintenance plan to do the backups and then you would schedule it to run once a month. See here: http://www.databasedesign-resource.com/sql-server-maintenance-plan.html

Answer 2

You can create a scheduled task and call the SQL method. Think about using a VB script or so. I did this for backing up a SQL server to a zip-drive every day and it worked great.

Answer 3

You could do this with a database script and a scheduled task. Visit this link for more details.

Answer 4

take a look here

Answer 5

Why do you only want to backup once a month?

Are you prepared to lose one month's worth of data?

Answer 6

If this is SQL Express you can't use Maintenance Plans, you'll need something like http://expressmaint.codeplex.com/