SQL Server : The complete course about BACKUP and RESTORE.

Name: SQL Server : The complete course about BACKUP and RESTORE.
Rating: 4.7 (42 reviews)

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

Last updated 7/2023

English

What you'll 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.

Course content

6 sections • 26 lectures • 2h 26m total length

Small explanation on the subtitles0:47
Learn how to manage subtitles in online videos, including deactivating subtitles on Udemy and YouTube, and understand why subtitles were added to better support you.

Why you should to backup your data?2:10
In this module, I talk to you about the importance of backing up this data on a SQL Server. And also possible scenarios of Backup and restore that we often meet in business
Démo: Simple BACKUP and RESTORE6:31
In this vidéo, you will learn how to backup ans restore a database in SQL Server.
The Syntax is : BACKUP DATABASE and RESTORE DATABASE
More détails in this vidéo, You will see It's really simple to do it
And have fun :)
Démo : BACKUP and RESTORE LOGS4:27
In this vidéo, you will learn how to backup ans restore a database in SQL Server.
The Syntax is : BACKUP LOGS and RESTORE LOGS
More détails in this vidéo, You will see It's really simple to do it
And have fun :)
Démo : Differential BACKUP and RESTORE6:42
In this vidéo, you will learn the définition of the Differential BACKUP in SQL Server.
Différential is a powerfull solution, because if you should restore many logs the differential wil help you to waste your time :)
More détails in this vidéo, You will see It's really simple to do it
And have fun :)
Démo : BACKUP WITH INIT5:38
BACKUP WITH INIT prevents stacking of backups, more détails in this vidéo
Démo : BACKUP WITH COPY ONLY8:31
BACKUP WITH COPY_ONLY avoid to break the BACKUP chain during all the day
Never forget this option, if you make a backup on production!
Démo: RESTORE moving the directory files3:52
In this démo, I'll type a script SQL, to show you, how to mode the file directory, when you restore a database.

Démo: The different database recovery model in SQL Server8:46
In this vidéo, we will see the different database recovery model :
- FULL, SIMPLE and BULKED LOGGED !
What are their difference and how to change it ?
And have fun :)
Démo: What is the Tail log backup ?6:07
In this démo, we 'll see the powerfull of a TAIL LOG BACKUP.
Always keep in mind, this Technic to recover the datas, with the NO TRUNCATE syntax !
Démo : BACKUP WITH CHECKSUM4:27
BACKUP with CHECKSUM check whether there is any corruption during our backup.
It's a powerfull option and don't forget to set up this option on your backup strategy.
Démo : How to RESTORE just a single page !4:21
In this demo, we will see the power of restoring a page on SQL Server.
This can save you hours and hours of restoration time in case of a crash on your server!
Démo: RESTORE WITH STOPAT5:53
RESTORE WITH STOPAT, is a powerfull option, which allows to RESTORE the LOGS at a given moment, at the close second, or the close minute, for example the data at 9:31:52 sharp.
More détails in this vidéo
Démo : RESTORE WITH STANDBY6:10
STANDBY is an interesting option that allows us to examine data between every restoration. It can be very useful if we want to restore one precise data but, we don’t know when the modification was done.
More détails in this vidéo.
Démo : RESTORE from a SNAPSHOT2:15
In this démo, You will see that's it's possible to do a RESTORE from a SNAPSHOT.
More détails in this vidéo
Démo : How to RESTORE from a LSN ? (log sequential number)4:24
It’s saves SQL log transactions that is only identified by a sequential number in the logs, and in every action, a unique LSN comes.
We can restore from the unique number of the LSN.
More détails in this vidéo
Does a COMPRESSION do a CHECKSUM ?5:35
So, does compression do a checksum? It’s a debate that you often find in the SQL forums.
There are some people that say it does, and there are others that says it doesn’t
More détails in this démonstration.
Démo: Understand what is a CHECKPOINT on your SQL Server engine11:37
I had to tell you about the CHECKPOINT in this course, because you have to understand the mechanism between the memory, the buffer pool and the disks where your data is stored.
We will show what the checkpoint does which is an internal mechanism in the SQL engine, that is completely transparent.
More détails in this vidéo.
Démo : Consult BACKUP and RESTORE metadata6:17
Explore how to consult backup and restore metadata in SQL Server, including backup sets, media, history, and verify backup validity.

Démo: How to increase performance, with BACKUP on several files !4:44
If there is one option, you have to remember on SQL Server, concerning your BACKUP and your RESTORE, it is the backup on several files !!
More détails in this vidéo
Démo: BACKUP WITH COMPRESSION and WITH MIRROR7:16
The Backup in MIRROR allows to do a BACKUP of the same BACKUP, on several distinct directories at the same time.
Compressing the BACKUP, sometimes, not all the time, can improve the BACKUP performance, because the volume of the physical writing is less.
More détails in this vidéo :)
Démo : BACKUP WITH BUFFERCOUNT and MAXTRANSFERTSIZE9:34
In this démo, We will see two options for your BACKUP :
BACKUP WITH BUFFERCOUNT and MAXTRANSFERTSIZE
We can add options to improve backups but you'd better use them sparingly, as this will be useful in some cases, but in others performance may degrade by changing some settings of BACKUPs.
More details in this vidéo

Never forget to BACKUP yours system database !!!3:31
Never forget to back up your system databases, this is crucial.
Many people forget to save them, and when a corruption occurs – something that rarely happens - on these system databases, it’s a disaster, we must reinstall, restore everything so, I strongly advise you to back up your system databases.
Démo : How to RESTORE your MASTER system database ?5:56
In this vidéo, we will see how to Restore the system databases Master and Model.
Reminder, if these databases are not available, you can't connect to your SQL Server engine !!!
More détails in this vidéo
Démo : How to RESTORE ALL systems databases ?6:40

Requirements

Just one computer, with Management Studio installed

Description

Did you know that you can perform with your BACKUP?

Are you sure you have an effective and robust BACKUP strategy in place?

Have you ever heard of the TAIL LOG BACKUP ?

This course is divided into two chapters:

The first part, is the beginner's level part, where we will discuss the :

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.

Why start SQL administration?

SQL Server is one of the skills very actively sought after on the job market.
Administering an SQL server today is ensuring that you have a full-time job.
No demo is longer than 10 minutes (so it won't be too soporific).
Moreover, SQL Server, because of its simplicity, allows you to quickly become competent in very specific areas.
Following this course will help you to stand out technically from your colleagues, or during a job interview, I guarantee it.

Who this course is for:

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

SQL Server : The complete course about BACKUP and RESTORE.

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

BACKUP and RESTORE beginner level7 lectures • 38min

Let's go a little further in BACKUP and RESTORE11 lectures • 1hr 6min

How to make SQL Server BACKUPS go faster3 lectures • 22min

How to RESTORE your system database ?3 lectures • 16min

Conclusion1 lecture • 4min

Requirements

Description

Who this course is for: