SQL Server DBA Tutorial 74-Manually Take Tail Log Transaction Log backup of a Database in SQL Server

Sdílet
Vložit
  • čas přidán 12. 09. 2024
  • In this video you will learn how to take Tail Log Transaction Log backup using sql server management studio as well as T-SQL script. After watching this video you will be able to take transaction log backup, Tail Log backup options, store the backup at different location, define database expiry option, backup completion status, how to restore full backup, how to restore differential backup, how to restore Transaction backup (T-Log) and how to restore Tail Log backup of a database in sql server 2008, 2012 as well as 2014. You will also learn recovery options of database while restoring database in sql server 2012.
    Blog post link for this video:
    sqlage.blogspot...
    Visit our website to check out SQL Server DBA Tutorial Step by Step
    www.techbrother...

Komentáře • 15

  • @IqbalButtUCO
    @IqbalButtUCO Před 8 lety +2

    Amazing video. Thanks TechbrotherIT

    • @mishrashiva9543
      @mishrashiva9543 Před 4 lety

      What is the difference between t-log,tail log and transaction log???

  • @kunnudev7250
    @kunnudev7250 Před 4 lety +1

    Great job please continue awesome videos

    • @mishrashiva9543
      @mishrashiva9543 Před 4 lety

      What is the difference between t-log,tail log and transaction log???

  • @analainvlogs9214
    @analainvlogs9214 Před 4 lety +2

    Thank you..it does help.

    • @TechBrothersIT
      @TechBrothersIT  Před 4 lety

      Glad it helped

    • @mishrashiva9543
      @mishrashiva9543 Před 4 lety

      @@TechBrothersIT What is the difference between t-log,tail log and transaction log???

  • @andreigiubleanu
    @andreigiubleanu Před 9 lety +2

    Very good work!

    • @TechBrothersIT
      @TechBrothersIT  Před 9 lety

      +Andrei Giubleanu Thanks you dear!

    • @mishrashiva9543
      @mishrashiva9543 Před 4 lety

      @@TechBrothersIT What is the difference between t-log,tail log and transaction log???

  • @mishrashiva9543
    @mishrashiva9543 Před 4 lety +1

    What is the difference between t-log,tail log and transaction log???

  • @Krishna-pk9up
    @Krishna-pk9up Před 5 lety +2

    Wo no truncate option hai

    • @mishrashiva9543
      @mishrashiva9543 Před 4 lety

      What is the difference between t-log,tail log and transaction log???

  • @paracha3
    @paracha3 Před 8 lety +2

    The word is "minimize" :-)