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

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
www.techbrother...

[@binyammamo6454]

You are the best.

[@TechBrothersIT]

Thank you

[@andreigiubleanu]

As usual, straight on the point.

[@ajithkumar02]

Well said

[@PavanKumar-bj4bk]

Awesome video regarding backup types...

[@TechBrothersIT]

+Pavan Kumar Thanks dear!

[@PavanKumar-bj4bk]

+TechBrothersIT i used to watch your videos for DBA knowledge and videos are simply awesome. Could you please provide link to download all DBA videos at a time....

[@hassantarish4771]

Superb way of explanation, thanks! :)

[@TechBrothersIT]

You are very welcome. Thanks for watching and support.

[@alejandrocuervo4411]

Thank you really good

[@debojitacharjee]

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?

[@lakshayarora3935]

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

[@akanshasoni6040]

I am unable to understand T- log backup

[@isaacklaas5722]

Cant see your commands from ssms

[@dwise1StreamingJoy]

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.

[@JunaidAhmed-ox2xd]

where's the next part ?

[@TechBrothersIT]

Hi Junaid, please check this out where we have put all the links in step by step, easy to follow. www.techbrothersit.com/search/label/SQL%20SERVER%20DBA%20Video%20Tutorial

[@jesevillatoro7098]

Make a ppt at least jeez