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.

Mark Bell · Accepted Answer · 2009-10-09 11:08:47Z

4

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

answered Oct 9, 2009 at 11:08

Mark Bell

29.8k26 gold badges121 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

stuartd · Accepted Answer · 2009-10-09 11:09:49Z

1

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

answered Oct 9, 2009 at 11:09

stuartd

73.7k16 gold badges139 silver badges172 bronze badges

Comments

amr osama · Accepted Answer · 2009-10-09 11:14:01Z

0

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

answered Oct 9, 2009 at 11:14

amr osama

1,1592 gold badges19 silver badges35 bronze badges

Collectives™ on Stack Overflow

Automatically backup SQL Server database

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related