Creating a Full Database Backup with SSMS

If you're new to SQL Server you might be creating a backup by stopping the service and copying the MDF. It works, but it's the hard way. Let MVP Brian Knight show you how to execute a full backup from Management Studio quickly and easily.

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.

Emery on 2/13/2009

Very Informative Brian. Thanks for all your videos!

Leela Krishna on 2/13/2009

Covered only basics.

Bruce Bealer on 2/13/2009

I would like a bigger picture. When I go to full screen the picture has a low resolution. I can't always see the text

Tri D Bui on 2/17/2009

Please detail about placement of STAT in the SQL statement; otherwise, excellent presentation. Thanks.

Steve M on 2/18/2009

I wonder what percentage of MSSQL users actually use the default folder on the C: drive. Our shop never does. Thanks for pointing out the script button, which I had never noticed before, and I've been working with MSSQL for several years.

4A5ADA4D6E on 2/20/2009

Thanks for the information. I am just getting used to the 2005 interface, so very helpful...

Andrew Hagel on 2/27/2009

A fair amount of eye strain, but worth the effort

sugarfreeless on 4/19/2009

I like this but prefer the other video using a maintenance plan to other tasks including backup to all databases instead of just a backup.

ramu on 11/18/2009

It will be very help fill if you can make a video on trasactional log back up

Aamir Ali Ansari on 12/18/2009

Perfect for first timers

dhanuja on 1/2/2010

interesting