SQL Server Backup Basics

In this episode, Brent Ozar explains the very basics of SQL Server backups for non-DBAs, including the differences between full backups, log backups and differential backups.

For more information, check out the SQL Server Backup & Recovery topic in the wiki:

http://sqlserverpedia.com/wiki/Backup_&_Recovery

You can view this video in higher quality or your favorite portable formats at:

http://sqlserverpedia.com/blog/podcasts/backup-basics/

Category:

Science & Technology

Tags:

• SQL Server
• Backup
• Recovery
• Quest Software
• Brent Ozar
• SQLServerPedia

[rominaloutaif]

Thank you! Excellent tutorial

[xmikedanielsx]

There is something a lot of people need to know. The things people need to understand 90% of DBAs do not write to a network drive automatically most of the time because you can't SQL wants to write locally due to permission issue. I love your coverage of all the specs about the sql compression etc. I have wrote a nice tutorial with sql server (includes a .BAT). I am currently writing a batch script that takes intermittent back ups (1 a month) and differentials.. very shortly.

[satishckm]

Super hero,

Gud one.......