Rating 4.25 out of 5 (23 ratings in Udemy)
What you'll 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 …
Rating 4.25 out of 5 (23 ratings in Udemy)
What you'll 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.
DescriptionThis course brings together two of my courses on the Udemy platform which are :
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 BULKEDLOGGUED), 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.
The second chapter will talk about corruption on SQLServer :
Database corruption happens all the time, all over the world !! When it happens in your environment, do you know what to do?
This 2-hour course will show you what you need to know to detect and repair most cases of database corruption.
The course begins by explaining why early detection of corruption is so important, and then examines the different causes of database corruption.
You will learn how to configure SQL Server to automatically detect when I/O errors occur.
You'll learn how to configure SQL Server to automatically detect when I/O errors occur, what consistency checks are, the DBCC commands to use to perform consistency checks, and how to configure SQL Server to perform consistency checks regularly.
This course is aimed at all database administrators and developers who will learn how to react to a case of corruption.
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.
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.
