Understanding SQL Server Backup and Restore

Everyone knows that it's critical to have backups but it's amazing how few people make sure those backups can be restored properly! Too many times to count, Tim has been brought in by organizations to help recover failed systems where administrators simply didn’t know how to properly restore SQL Server backups when they have to. In this session, Tim will explain the various types of backups that can be taken and demonstrate how to restore each of them. Apart from covering the common full, differential and log backups, Tim will also cover partial, filegroup, and COPY_ONLY backups, backing up to and restoring from a URL, backup encryption, and how to perform a hack attach for the ultimate tail log restore. There's something here for everyone to learn!

Tim is a SQL Server MVP. He has presented at PASS, SQLintersection, SQL Saturdays, user groups and numerous webinars. In addition Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer in 2012. He’s married with three children and has a passion for electronics. He also farms chickens (for eggs) and tilapias in his spare time.

Links to PASS and our Site:

Use our discount code VGDISM843 to save $150.00 off the full price of PASS

[cecilchampenois]

Glad to hear someone offering this type of training, and also speaking clear English.

[CodeXploit]

Your chanel is a goldmine of usefull knowledge. I just started as DB admin after 15 years of being Server Admin and your videos are helping expand my knowledge. Thank you sir.

[jonkumbi]

This is good information for all those who want to know SQL. Thank you ..

[rightiousangel]

Absolutely amazing job. Definitely not for beginners. Amazingly I understood everything you covered and you were very efficient. Those files are definitely gonna be a good source if info for me. Thank you.

[tomarakelian]

Very helpful, thank for clear explanation, perfect video.

[andrejtroschin]

Thank you for a very good explanation.

[harshitmunjal]

How to restore my backup of Old sql but I also don't how to install SQL server 2008 plzz give me somution

[anonofDeath]

38:16 Why was there two log files in different locations and why did he have to overwrite the originial one?

[odiboufuoma]

hi. well explained i really enjoy your teaching. could please share some knowledge on Powershell scripting to automate backup's job?

[raissascott]

How can I get the complete script you use in this demo?

[tarikhhistory]

I Need the scrips, i did't find the scripts in that link which you have share.
Please share the scripts.

Very good explanation.

[AgnaldoJuniorCarmo]

I want the script responsible to generate restore strategy

[scramble]

terrible confusing without explanations of what each term means