* Cantinho Satkeys

Refresh History
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    Hoje às 10:40
  • j.s.: dgtgtr a todos  4tj97u<z
    07 de Julho de 2025, 13:50
  • FELISCUNHA: Votos de um santo domingo para todo o auditório  4tj97u<z
    06 de Julho de 2025, 11:43
  • j.s.: [link]
    05 de Julho de 2025, 16:31
  • j.s.: dgtgtr a todos  4tj97u<z
    05 de Julho de 2025, 16:31
  • j.s.: h7t45 ao convidado de Honra batatinha pela sua ajuda
    05 de Julho de 2025, 16:30
  • FELISCUNHA: ghyt74  pessoal   4tj97u<z
    04 de Julho de 2025, 11:58
  • JPratas: dgtgtr Pessoal  101041 Vamos Todos Ajudar na Manutenção do Forum, Basta 1 Euro a Cada Um  43e5r6
    03 de Julho de 2025, 19:02
  • cereal killa: Todos os anos e preciso sempre a pedir esmolas e um simples gesto de nem que seja 1€ que fosse dividido por alguns ajudava, uma coisa e certa mesmo continuando isto vai levar volta a como se tem acesso aos tópicos, nunca se quis implementar esta ideia mas quem não contribuir e basta 1 € por ano não terá acesso a sacar nada, vamos ver desenrolar disto mais ate dia 7,finalmente um agradecimento em nome do satkeys a quem já fez a sua doação, obrigada
    03 de Julho de 2025, 15:07
  • m1957: Por favor! Uma pequena ajuda, não deixem que o fórum ecerre. Obrigado!
    03 de Julho de 2025, 01:10
  • j.s.: [link]
    02 de Julho de 2025, 21:09
  • j.s.: h7t45 ao membro anónimo pela sua ajuda  49E09B4F
    02 de Julho de 2025, 21:09
  • j.s.: dgtgtr a todos  4tj97u<z
    01 de Julho de 2025, 17:18
  • FELISCUNHA: Votos de um santo domingo para todo o auditório  4tj97u<z
    29 de Junho de 2025, 11:59
  • m1957: Foi de boa vontade!
    28 de Junho de 2025, 00:39
  • j.s.: passem f.v. por aqui [link]    h7t45
    27 de Junho de 2025, 17:20
  • j.s.: renovamos o nosso pedido para uma pequena ajuda para pagemento  do nosso forum
    27 de Junho de 2025, 17:19
  • j.s.: h7t45 aos convidados de honra Felizcunha e M1957 pela ajuda
    27 de Junho de 2025, 17:15
  • j.s.: dgtgtr a todos  4tj97u<z
    27 de Junho de 2025, 17:13
  • FELISCUNHA: ghyt74  pessoal  4tj97u<z
    27 de Junho de 2025, 11:51

Autor Tópico: SQL Server : The complete course about BACKUP and RESTORE  (Lida 127 vezes)

0 Membros e 1 Visitante estão a ver este tópico.

Offline mitsumi

  • Sub-Administrador
  • ****
  • Mensagens: 121842
  • Karma: +0/-0
SQL Server : The complete course about BACKUP and RESTORE
« em: 19 de Junho de 2021, 10:51 »

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 27 lectures (2h 26m) | Size: 1 GB
This course (3 hours) will teach you all the subtleties of BACKUP and RESTORE on SQL Server 2019

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.

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


Download link:
Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction