SQL Server DBA Tutorial 70-What is Database Backup & How Many Types of Backups available

preview_player
Показать описание
In this video you will learn what is database backup, why we need database backups, what are the best practices of backing up SQL Server databases. It also illustrates how many types of backups available in SQL Server, what is Full backup? What is Differential Backup and what is Transaction Log backup. It also shows different scenarios of backup strategy in real time production environment. it is part of complete SQL Server DBA Tutorial.

Visit our website to check out SQL Server DBA Tutorial Step by Step
Рекомендации по теме
Комментарии
Автор

Awesome video regarding backup types...

PavanKumar-bjbk
Автор

Superb way of explanation, thanks! :)

hassantarish
Автор

Plz help me in one scenario.
I took backup of a db and when I was restoring that backup into other server, that backup file is not visible. I also added suffix of bak. Still backup file not visible. Plz help me out

lakshayarora
Автор

I am unable to understand T- log backup

akanshasoni
Автор

I didn't understand one thing here... incase of text files if any modification is made in the text after full backup and incremental backups are made then during restoration what will happen to the text file if it was modified two times? Then the text file will be replaced with the recent incremental backup or it will be replaced twice for two incremental backup? Also if it was a diffrential backup then what will happen to the backup file after two modifications? Will that text file will be replaced two times while backup or two copies will be created during differential backup?

debojitacharjee
Автор

please can you send me an email on how i can take a training from your company online. or any module in udemy from you i can us to study.. thanks.

dwiseStreamingJoy