3

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.

5
  • Since you're a newbie, I'd suggest starting here: technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx
    – Joe Stefanelli
    Jul 14, 2010 at 15:46
  • Why do you only want to backup once a month? Are you prepared to lose one month's worth of data?
    – bearrito
    Jul 14, 2010 at 19:22
  • what version of SQL 2005?
    – Malnizzle
    Jul 14, 2010 at 19:26
  • The version is SQL 2005, we need to know what edition it is.
    – joeqwerty
    Jul 14, 2010 at 21:25
  • Every month? Don't you mean every day? Or don't you value that data? Jul 14, 2010 at 21:28

6 Answers 6

11

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

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.

1
  • 1
    please show me how
    – I__
    Jul 14, 2010 at 15:49
1

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

1

take a look here

0

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

0

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .