Author:

Author Bio:

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

Automating SQL Express Backups

SQL Express has no mechanism to schedule backups and maintenance of your instance. In this video, Brian shows you how to automate and schedule backups of SQL Express with a simple scripted solution.

Video Information
Publish Date:	August 14, 2006
Length:	11:46
Skill Level:	200
Rating:	4.07 out of 5

Watch Video Now! Watch it later!

Rate This Video:	12345
	1=Poor, 3=Good, 5=Excellent

Comments:

WChaster on 9/2/2008

Where are the relaed links?

CHEN on 11/16/2008

the video was very helpfull!! thank you very much!

Clark on 11/24/2008

Nice work for solving a problem for SQL Express.

infamous carlos on 12/16/2008

It would have been nice if he had added some issues that he may have run across while setting up the scripts

Syed Arshad on 4/19/2009

jim tetler on 4/30/2009

Fantastic! I tweaked it to make continuous backups not just 7 days naming the file with the date - has worked flawlessly for 9+ months

nasir on 5/5/2009

very nice

Jamshid Nouri on 5/12/2009

Excellent video

01EFFB45CF on 9/30/2009

Wish I knew about this years ago. Looks like SQL Express 2008 has an agent but I will use this one because it is so simple.

Ole Mygind on 10/21/2009

HELP --- Where did the sample script files go ??? Website seems to be down :-(

Carlos on 1/26/2010

Excellent solution but where are the files??? Page Not Found!!???

Steve Ramp on 6/15/2010

Very good and necessary information for Express use.


Must Be Logged In

References

Blog post

Instructions and download about this solution.

Download the Sample Code

The project Brian describes in his video.