I’ll be at SQLSat #54 this weekend 10/23 and will be presenting a couple of topics.
Backup & Restore Basics
The key to being able to recover data in an emergency is to have a good backup and to know how to restore that backup to get up and running again as quickly as possible. In this session we’ll talk about how to design a backup and restore strategy that’s a good fit for you, including discussion around the types of backups that can be taken. We will also work through a couple of demos showing backup and restore in action. After all a backup is only good if you can restore it.
Be safe out there: Ship those logs
What happens if your hardware fails or your data center loses power? Do you have a Disaster Recovery (DR) plan in place that you can implement quickly? Log shipping allows you to keep copies of your databases closely synced and ready to come online in an emergency. Log shipping also offers options for read-only warm standby databases to reduce load from your production servers, adding additional value to your investment. In this session we’ll Log Shipping, how it works, and how it differs from its cousin, Mirroring. We’ll discuss practical uses for Log Shipping and work through a demonstration to show you how you can get it up and running in your environment.
Be sure to find me and say hello if you’re attending.