Brent Ozar 4.83
Developers and accidental DBAs: if you know more about how SQL Server handles crashes and disasters, you’ll be able to make a better decision about how to prepare. In this session, I will cover all of SQL Servers backup and high availability options at a high level, including clustering, log shipping, mirroring, replication and more. I’ll show the pros and cons of each, and teach you how to pick the right method for your application. We won’t have enough time to dive into actual implementation demos due to the number of solutions we’ll cover, but we’ll show screen shots and give links to the best resources for each method.