Backup ... set ... Restore!
SQL backups within your enterprise should be like making coffee, good and often! One of the most important aspects for a database environment is ensuring reliable backups are being executed and a dependable recovery plan is established in case of a system failure or data corruption.
Setting up basic backups is quite simple. Adding on log backups and differentials is easy as well. However, in real life, we still see a lot of wrong backup configurations and backup failures!
In this session, you will learn about the backup and restore strategies, the different recovery models, the main backup types, implementing restore scenarios, restoring a full backup, restoring to a point in time and backup/restore best practices.
Sorry, there are no downloads available for this session.
Pieter Vanhove is a SQL Server MVP and Database Consultant at
Kohera in Belgium and has been working with SQL Server since 2000. Performance
tuning, SQL audits, migrations and training are part of the job. Pieter has
also a profound knowledge in implementing high availability and disaster
recovery solutions and loves the new Azure stuff. Together with the SQLUG in
Belgium, he helps organizing SQL Server Days and is also a regular speaker at
Belgian and international events. Pieter recently won the Speaker Idol Contest at PASS Summit 2014.
The video is not available to view online.