This course brings together two of my courses on the Udemy platform which are :
SQL server : Detecting and repairing corruption on a database
SQL server : The complete course about BACKUP and RESTORE.
The first chapter will talk about BACKUP and RESTORE :
How to make very simply a BACKUP and a RESTORE.
Discuss the BACKUP LOGS and DIFFERENTIAL BACKUP, and why it is absolutely necessary to implement them in your BACKUP strategy.
Understand the interest of the WITH INIT in a BACKUP, and learn how to make a restoration in time with the WITH STOPAT option.
And finally, we will see the different full recovery model on a database(FULL,SIMPLE and BULKED LOGGUED), and why this is (very) important for our BACKUPs.
The second part, which is longer, is the part of a more advanced level, we will discuss :
The performance when doing a BACKUP on several files.
Avoiding corruption on BACKUPs with the CHECKSUM, and understanding 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.
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.