Understanding SQL Server Backup and Restore Tim Radney

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), dwarf Nigerian goats, and tilapias in his spare time.
Links to PASS and our Site:
PASS: Pass.org
DBAFundamentals: fundamentals.p...
Why to Go: • Why Go to PASS Summit?
Use our discount code VGDISM843 to save $150.00 off the full price of PASS
Registration can be completed here: www.pass.org/s...

[@MagalieMebua]

Thanks for the contents, Tim.

[@jeroendankelman9641]

Tim, thanks for this clear explanation!

[@satishgarepalli5977]

Excellent presentation..Missed split backups, mirror backups, backup to disk='null'. I am just reminding this not to dis respect but wonderful explanation...