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...
Excellent! Thanks
This is great, thank you!
Great video, thanks a lot... 🌹
ok so that option doesn't appear, now what
Can you just export the logs replay them later without a second instance. Once you fixed the initial server instance?
what would happen if the primary and secondary SQL versions were different? Is it possible to do log shipping?
You cannot restore a databases from a newer version of sql to one with an older. Even with compatibility