SQL Server : The complete course about BACKUP and RESTORE.

This course (3 hours) will teach you all the subtleties of BACKUP and RESTORE on SQL Server 2019.

Created by: ELOA FORMATION | SQL | Postgres | Powershell| MySQL | Python | TSQL Administration,TSQL, and SQL Server performance.
Join the masterclass SQL Server course !

What Will I Learn?

• How to make very simply a BACKUP and a RESTORE
• Discuss the BACKUP LOGS and DIFFERENTIAL BACKUP, and implement them in your BACKUP strategy.
• Understand the interest of the WITH INIT in a BACKUP
• we will see the different full recovery model on a database (FULL,SIMPLE and BULKED LOGGUED)
• The performance when doing a BACKUP on several files.
• Avoiding corruption on BACKUPs with the CHECKSUM
• Understand the importance of BACKUP WITH COPY ONLY to avoid breaking the BACKUP chain during the day.
• To discover that you can make a RESTORE of a page, or from a LSN, to avoid losing hours of RESTORE, in case of server crash.
• Recover unsaved logs, in case of server crash, with the power of the TAIL LOG BACKUP.
• We will discuss the BACKUP WITH COMPRESSION,to save disk space, which can be significant
• and the simultaneous copy of BACKUP with the WITH MIRROR option.
• We will also see how to restore system databases (Master, MSDB, model, TEMPDB).
• The RESTORE WITH STANDBY, which allows to examine the data between each RESTORE.
• Understand what is a CHECKPOINT on your SQL Server engine
• And to finish, we will see how to make a RESTORE from a SNAPSHOT, see the necessary rights, to make BACKUP, how to consult BACKUP metadata.

Requirements

• Just one computer, with Management Studio installed

Target audience

• Future Database Administrators (DBA)
• Developers who want to learn about SQL
• BI consultants working on technologies other than SQL Server (Oracle etc...)
• Students who want to get started on SQL
• Tech leads (CRM, Web etc...) who want to discover SQL