How to Configure Log Shipping

Sdílet
Vložit
  • čas přidán 25. 08. 2021
  • Start learning cybersecurity with CBT Nuggets. courses.cbt.gg/security
    In this video, Garth Schulte covers configuring log shipping - giving you a standby copy of your database living on another instance of SQL Server.
    It goes without saying that disaster recovery is a crucial necessity for any company using large databases - log shipping helps make sure your SQL Server has a standby copy to revert to at any time. Follow along with Garth as he manually configures log shipping inside his sample database.
    📁 Download the Ultimate Sysadmin Cert Guide: blog.cbt.gg/6zrb
    ⬇️ 4-Week Study Plan: MD-100 & MD-101: blog.cbt.gg/8l11
    Start learning with CBT Nuggets:
    • Microsoft MCSE: Data Management and Analytics | courses.cbt.gg/ezw

Komentáře • 6

  • @FragrantVagrant69
    @FragrantVagrant69 Před 2 lety

    This is great, thank you!

  • @hoomaneru
    @hoomaneru Před 2 lety

    Great video, thanks a lot... 🌹

  • @penpal5900
    @penpal5900 Před rokem

    Excellent! Thanks

  • @jus4027
    @jus4027 Před 2 lety

    Can you just export the logs replay them later without a second instance. Once you fixed the initial server instance?

  • @gunzidiot
    @gunzidiot Před 10 měsíci +1

    ok so that option doesn't appear, now what

  • @zahramirzaei2017
    @zahramirzaei2017 Před 8 měsíci

    what would happen if the primary and secondary SQL versions were different? Is it possible to do log shipping?