How to Configure Log Shipping
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
This is great, thank you!
Great video, thanks a lot... 🌹
Excellent! Thanks
Can you just export the logs replay them later without a second instance. Once you fixed the initial server instance?
ok so that option doesn't appear, now what
what would happen if the primary and secondary SQL versions were different? Is it possible to do log shipping?