Home / server / Questions / 160382
Accepted
Alex Gordon
Asked: 2010-07-15 07:44:07 +0800 CST

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

  • 772

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.

sql-server sql

6 Answers

  1. Best Answer

    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

    • 11

  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.

    • 2

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

    • 1

  4. take a look here

    • 1

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

    • 0

  6. You could use a VB Script I wrote exactly for this purpose: https://github.com/ezrarieben/mssql-backup-vbs/

    Schedule a task in the "Task Scheduler" to execute the script as you like and it'll backup the entire DB to a BAK file and save it wherever you specify.

    • 0