Maintaining SQL Server 2005 Databases - Backups

In this presentation for SQL Server newbies, you'll learn how to maintain your SQL Server databases by backing them up regularly and reindexing them. This topic assumes you know nothing about SQL Server and also covers some of the decisions you'll have to make when you decide you want to backup your database through maintenance plans.

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.

SharathK on 11/25/2008

Very good introductory session, would like more advanced sessions

SharathK on 11/25/2008

Very good introductory session, would like more advanced sessions

suryavithala on 1/2/2009

Excellent video for starters.

extremenovice on 1/31/2009

That was great!,i am new to sql server 2005, but have been on a course for Maintaining Sql Server db and it never shown me that a maint plan wizard would do that.So ive wasted alot of my time by doing each backup, shrink jobs for each db individually. My nightmare is over :-)

fusilier on 5/12/2009

Great video... Simple and easy to follow.

Christian Bahnsen on 6/5/2009

These videos are great. Thanks so much.

Narayana on 7/14/2009

Very good Vedio

ramu on 11/16/2009

Wow Gr8 job that was good job and it helps a lot for beginer's thanks for the video keep doing this kind of videos for back up in different ways

karan on 12/18/2009

very good explanation

Ranjith on 2/9/2010

Nice Brian as always

01EFFB45CF on 3/9/2010

Wow. I feel a little dumb. I spent time writing SMO scripts to back my stuff up, but all I had to do is watch this video. Man! What you don't know can hurt you. It also showed me how to tame the SharePoint dbs that grow out of control on the C: drive. Great video.

George on 7/6/2010

Very informative.. keep it flowing Brian

James Lawrence on 7/9/2010

Very informative.

Todd Consentino on 7/29/2010

Be careful if you select Shrink Database, as it may lead to database fragmentation.

MohanD on 10/19/2010

Good one

FD928096BE on 10/23/2010

Excellent

Sean on 4/12/2011

I thought it was suggeted that we don't use the Shrink database command.

32B941FBF4 on 4/14/2011

I think you should have discussed more about best practices when your teaching new DBA's to-be.