In this module, you will gain knowledge on how to backup your own database using SQL Server 2019 back-up strategies. At the same time, you will learn how to restore your database securely from the damaged DB. Furthermore, you will get through some more additional concepts such as recovery models, types of backups, point-in-time recovery, and many more.
- Recovery Models Setting Recovery Model
- Database Backups
- Backup Types Copy-Only, Mirrored and Tail log backups
- Full
- Differential
- Transaction Log
- File or Filegroup
- Backup Devices
- Performing Restoration
- Backup System Databases
- Point-in-time Recovery
- Viewing complete details of the backup process
- Issues related to backups
Learning Outcome
You will be able to perform backup your database using various backup models present in the SQL Server 2019 by the end of this section. You can even restore your database at a point-in-time. Finally, You will also be in a position to understand page-level restore, group file restore, and many more in a clear way.