Automatically backup SQL Server database

Question

I need to backup SQL Server database.

Is it possible to do this automatically without human intervention at regular intervals? If so yes then please suggest me how to do it and I'm using SQL Server 2005 Express Edition.

Answer 1

You'll need this:

http://www.codeplex.com/ExpressMaint

Then you can create a .cmd file to run it and schedule it using Scheduled Tasks. I can't give you an exact command line because your setup will be different from mine, but the docs are here:

http://www.sqldbatips.com/showarticle.asp?ID=27

http://www.sqldbatips.com/showarticle.asp?ID=29

Answer 2

There's a walkthrough on backing up SQL Server Express here

Answer 3

in sql 2005 scripts templates you will find backup script

from your code run this script in the time you want to backup your database

thats it i guess

Answer 4

Hey, check this tool http://sqlbackupandftp.com You can do scheduled backups with it.

Answer 5

SQLBackupAndFTP wins hands down