Understanding SQL Server Backup and Restore

Published: 15 April 2016
on channel: DBAFundamentals
82,976
499

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:

PASS: Pass.org

DBAFundamentals: https://fundamentals.pass.org/default...


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: https://www.pass.org/summit/2019/Regi...


Watch video Understanding SQL Server Backup and Restore online without registration, duration hours minute second in high quality. This video was added by user DBAFundamentals 15 April 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 82,97 once and liked it 49 people.