SQL Server Recovery Model || Full Vs Bulk Logged Recover Model || Diff Between Full and bulk logged

  Рет қаралды 3,719

Tech and Art

Tech and Art

Күн бұрын

Пікірлер: 9
@mandyallinone5336
@mandyallinone5336 2 жыл бұрын
Not all diff backup required sirji. Only Friday diff is sufficient.
@molkapurishivakrishna2963
@molkapurishivakrishna2963 Жыл бұрын
Thank you very much sir... I have a doubt.. Whenever we want to recover db.. First we need to take tail log back up... Okay.. Whenever we want to restore the db. Firstly: last full back up Second: last successful differential back up.. Third: all T-log backups from last successful differential back ups.. And finally: Tail log back up must be restored... Is it right? And I didn't get clarity regarding bulk logged recovery model.. Why can't we get point time recovery? Mean can't we take log back up or Tail log back up... Please clear my doubt sir...
@TechandArt
@TechandArt Жыл бұрын
Tail log backup u can't in bulk log recovery... Thanks for watching video.. Visit playlist of channel
@molkapurishivakrishna2963
@molkapurishivakrishna2963 Жыл бұрын
@@TechandArt thanks for reply sir... Iam watching your vedios sir...
@gurupanda4192
@gurupanda4192 3 жыл бұрын
Useful info thanks for sharing
@sagarkashid123
@sagarkashid123 3 жыл бұрын
Thanks for shearing request to You please cover possible mirroring senarios in one vedio same always on u had share.
@TechandArt
@TechandArt 3 жыл бұрын
Thanks buddy will do that soon ..... plz share the channel with others as well I need support from you guys ... you guys always cheers for me ..
@arnabpatra705
@arnabpatra705 3 жыл бұрын
Useful tips
@ramareddy6798
@ramareddy6798 3 жыл бұрын
Nice post
BAYGUYSTAN | 1 СЕРИЯ | bayGUYS
36:55
bayGUYS
Рет қаралды 1,9 МЛН
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 148 МЛН
黑天使被操控了#short #angel #clown
00:40
Super Beauty team
Рет қаралды 61 МЛН
Quando A Diferença De Altura É Muito Grande 😲😂
00:12
Mari Maria
Рет қаралды 45 МЛН
Querying 100 Billion Rows using SQL, 7 TB in a single table
9:07
Arpit Agrawal (Elastiq.AI)
Рет қаралды 56 М.
DBA - Recovery Model in SQL Server || SIMPLE||FULL||BULK LOGGED
13:48
SQL Server Log File is HUGE!
11:18
Kevin Hill
Рет қаралды 110 М.
SQL Server DBA Mock Interview 1
20:29
Solved Pages
Рет қаралды 6 М.
BAYGUYSTAN | 1 СЕРИЯ | bayGUYS
36:55
bayGUYS
Рет қаралды 1,9 МЛН