SQL Server 2019 : Administration SQL Server Part 1

In this 4 hour course, discover two very important modules : BACKUPS and RESTORES and corruption on SQL Server 2019.

4.15 (37 reviews)

Udemy

platform

English

language

Other

What you will learn

What are the common causes of corruption?

How to check the consistency of the data?

How to repair in case of corruption?

What to do when corrupting logs?

Control corruption on your backup with BACKUP WITH CHECKSUM

Explanation and demonstration on the CHECKDB

Discover TORN PAGE DETECTION and PAGE CHECKSUM

Discover DBCC IND and DBCC PAGE

Learn how to repair a non-clustered index

Recreating a log file by attaching a DB

Repairing a database using the HACK ATTACH mode

And discover all the techniques of RESTORE in case of corruption

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 Gallery

SQL Server 2019 : Administration SQL Server Part 1 – Screenshot 1 — Screenshot 1 – SQL Server 2019 : Administration SQL Server Part 1

SQL Server 2019 : Administration SQL Server Part 1 – Screenshot 2 — Screenshot 2 – SQL Server 2019 : Administration SQL Server Part 1

SQL Server 2019 : Administration SQL Server Part 1 – Screenshot 3 — Screenshot 3 – SQL Server 2019 : Administration SQL Server Part 1

SQL Server 2019 : Administration SQL Server Part 1 – Screenshot 4 — Screenshot 4 – SQL Server 2019 : Administration SQL Server Part 1

Loading charts...

SQL Server 2019 : Administration SQL Server Part 1

What you will learn

What are the common causes of corruption?

How to check the consistency of the data?

How to repair in case of corruption?

What to do when corrupting logs?

Control corruption on your backup with BACKUP WITH CHECKSUM

Explanation and demonstration on the CHECKDB

Discover TORN PAGE DETECTION and PAGE CHECKSUM

Discover DBCC IND and DBCC PAGE

Learn how to repair a non-clustered index

Recreating a log file by attaching a DB

Repairing a database using the HACK ATTACH mode

And discover all the techniques of RESTORE in case of corruption

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 Gallery

Related Topics