Want to become an expert on mirroring? Here’s a task list to run in your lab. Need a free place to test mirroring out quickly to get your feet wet? Want to read more advanced articles on more mirroring topics? Curious if SQL Server Basic Availability Groups in Standard Edition make mirroring irrelevant? Get the…
Streaming all that data over to a mirror server isn’t free, and it can impact your performance. Learn about monitoring database mirroring state changes and performance.
Learn how to use TSQL to change mirroring modes and initiate failover. Watch a demo where Kendra causes corruption in a database and the automatic page repair feature kicks in to solve the problem. Want to run that demo yourself? Get the scripts here!
Learn about potential trouble spots in database mirroring: split brain, suspended mirrors, disconnected witnesses, and why witness placement is critical.
Once we’ve defined our RPO and RTO goals, we need to pick the right SQL Server features to meet those goals. This module will teach you the pros and cons of clustering, mirroring, Always On Availability Groups, replication, log shipping, virtualization replication, and more.
