How to Configure Log Shipping

Поделиться
HTML-код
  • Опубликовано: 25 окт 2024
  • Start learning cybersecurity with CBT Nuggets. courses.cbt.gg...
    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...

Комментарии • 7

  • @penpal5900
    @penpal5900 2 года назад

    Excellent! Thanks

  • @FragrantVagrant69
    @FragrantVagrant69 3 года назад

    This is great, thank you!

  • @hoomaneru
    @hoomaneru 2 года назад

    Great video, thanks a lot... 🌹

  • @gunzidiot
    @gunzidiot Год назад +1

    ok so that option doesn't appear, now what

  • @jus4027
    @jus4027 2 года назад

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

  • @zahramirzaei2017
    @zahramirzaei2017 11 месяцев назад

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

    • @MiningForPies
      @MiningForPies Месяц назад

      You cannot restore a databases from a newer version of sql to one with an older. Even with compatibility