Udemy Certificate 0

SQL Server : The complete course about BACKUP and RESTORE.

Name: SQL Server : The complete course about BACKUP and RESTORE.
Price: 34.99 USD
Availability: InStock

About this course

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.

56/100

CourseAsk score

What the provider tells you: 32/45
Who stands behind it: 8/35
How complete the listing is: 16/20

Scores how much the provider publishes and who stands behind it — not how well it is taught.

What you'll learn

Understand basic and advanced backup strategies in SQL Server
Implement differential backups and LOG backups
Utilize the TAIL LOG BACKUP to recover unsaved logs
Perform page restores and restore from a specific LSN
Apply backup compression to save disk space
Manage backup processes across multiple files

Data Analysis #performance tuning #sql server #restoration #compression #restore #error prevention #backup strategy #differential backup #LOG backup #recovery models #CHECKSUM #copy only backup #TAIL LOG BACKUP #disk space management

$34.99

Price shown by Udemy — confirm on their site.

Enroll on Udemy

You'll be redirected to Udemy to complete enrollment.