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.

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.

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

5

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.

lital on 2/1/2011

Thanks a lot! cannot download the sample code.Any ideas?

Matteo on 4/12/2011

Links not working!

Doris on 4/12/2011

hihi... links not work

Paradoxical on 4/12/2011

An awesome presentation... thanks for providing professional quality instructional material!

Cosmin Tornea on 4/12/2011

cool

Kasey Wheeler on 4/12/2011

Nice video.

Ankit Khandelwal on 4/12/2011

Nice video

Dan on 4/12/2011

cannot download zip file - 404 error.

Joe DeMarco on 4/12/2011

Great video

Rod on 4/12/2011

I need something like this, so I really appreciate it.

Rod on 4/12/2011

I just tried clicking on the Download link, to download the BackupExpress.zip file, but it didn't go anywhere. Where is the .zip file?

Mark Holahan on 4/12/2011

Top notch! Great job Brian.

ravi on 4/12/2011

good

Bruce Bealer on 4/12/2011

This is the second video I watched that the link to the example is broken. Please fix

melissa on 4/12/2011

cannot download code

85F9D100CF on 4/12/2011

Good video, bad link to supporting files.

WChaster on 4/12/2011

Why not add the DOW variable to the log file too.

Maurice Ivory on 4/12/2011

I enjoyed this one...it had some length on it.

Maxwell Chaves on 4/12/2011

could provide the files used in the video?

Omair on 4/12/2011

Totally useful. Thanks.

Ronald McCullough on 4/13/2011

Like many others link to sample code resutls in 404 error ......

Michael Neymit on 4/13/2011

Excellent, thank you!

Robert Johnson on 4/13/2011

The link for downloading the sample code does not work for me.

Howard Bock on 4/16/2011

Very good.

Howard Bock on 4/16/2011

Does anyone know how to download the file mentioned in the video?

Oded on 4/22/2011

Where is the source code?

ravi on 4/26/2011

good one

Karla Broman on 5/4/2011

This is great except that I can't find the link to download the file.