Backing Up Your Database With SMO

This video shows you how to backup your database using SMO.

Tim Mitchell is a Microsoft SQL Server database developer, business intelligence consultant, writer, and speaker. He has been working professionally with SQL Server for over six years, and holds the MCTS and MCDBA certifications from Microsoft as well as a Bachelor's degree in computer science from Texas A&M University - Commerce.

WChaster on 10/2/2008

Is the file available or do I just have to watch this repeatedly until I can type the script myself?

hades on 10/2/2008

Fantastico!!!!

richard on 10/28/2008

is the code available!!

Thomas Kaiser on 11/14/2008

I did not know you could even do this type of thing! Are scripts available for download?

yashpal on 9/22/2009

good

Carlos E. Mosquera on 10/7/2009

Don't show result files

Eric on 1/31/2011

This was my first intro to SMO, thank you kindly.

Steve Culshaw on 4/6/2011

Good video of SMO use case .... but a bit of a repeat of the other SMO video on looping through servers and backing up any database that hasn't been backed up in greater than 48 hours

Sankar on 4/6/2011

Cool stuff. Thanks, TIM

Cosmin Tornea on 4/14/2011

cool

Kasey Wheeler on 4/14/2011

Good video.

Don Weigend on 4/14/2011

What is a good resource for learning how to program in SMO?

Larry Johnson on 4/14/2011

In the past, I manually generate scripts from SQL Server database, including stored procs, views, UDFs, etc., and save them in VSS. Is it possible to use SMO to do this automated? Thanks! Larry Johnson

R Michael Lacy on 4/14/2011

Good but code link is invalid.

Talha on 4/14/2011

sexy tool

dfwdba on 4/14/2011

I'd like to see a lot more SMO examples.

Ludwig on 4/14/2011

great job. Thx

kid yu on 4/19/2011

it is useful. thanks a lot.

kid yu on 4/19/2011

it is useful. thanks a lot.

infamous carlos on 4/19/2011

would like to see the code

Gabor Balazs on 4/20/2011

Let's show what it did. Where is the backup? In the current folder or is the folder a predefined one.

Christian Bahnsen on 4/29/2011

Great job, Tim. I've been away from jumpstart for awhile but it's good to have access to it again. SMO, huh? I'm looking forward to your other videos in the series.

Russell Todd on 5/1/2011

c#???? Should have a vb.net option

Harish Wadhwa on 7/29/2011

Did not show weather the code really did the job. Code from video link is also not working.

Mike on 8/27/2011

Not sure where the Backup object resides. Made reference to using Microsoft.SqlServer.Management.Smo; but still cannot create a Backuo object as you show.