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)
199
students
4.5 hours
content
Nov 2022
last update
$44.99
regular price
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.
Screenshots
Related Topics
3426890
udemy ID
8/17/2020
course created date
11/6/2020
course indexed date
Bot
course submited by