Disaster Recovery
-
A Bad Day with Backups
I learned a hard lesson when I first started as a DBA. Although to be honest, it’s not a lesson I should have had to learn (I’ll keep you in suspense). I work for a large Fortune 100 company and as with many companies our size, there are many processes in IT. I was in…
-
HA and DR Precon in Denver
I’ll be doing a precon for SQLSaturday #331 in Denver Colorado on September 19th, 2014 titled “A Day of High Availability and Disaster Recovery” . If you can make it, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster Instances, AlwaysOn Availability Groups, and more.…
-
HA and DR Precon in Baton Rouge
I’ll be doing a precon for SQLSaturday #324 in Baton Rouge Louisiana on August 1st, 2014 titled “A Day of High Availability and Disaster Recovery” . If you can make it, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster Instances, AlwaysOn Availability Groups,…
-
Speaking at PASS DBA Virtual Chapter
I will be speaking for the PASS DBA Virtual Chapter on February 22nd, 2012. I will be delivering my presentation on Mirroring. If you have not checked out the virtual chapters that PASS has, then you need to Go Check Them Out. These chapters are designed to fill the gap for areas of the country that…
-
T-SQL Tuesday Mirroring and SSWUG
This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”. My favorite DR solution is mirroring. Mirroring is easy to setup and fast, if implemented properly. It’s a database level solution that allows you to keep a remote copy of your database in sync with your principal database. Everything is…
-
Mirroring Slides & Code
Mirroring: The Bear Necessities slide deck and sample code
-
Presenting on SQL Mirroring
Ryan Adams will be doing two presentations on SQL Mirroring this week.
-
Smoking SQL Mirror
You cannot mirror a database to two seperate servers, but there is an alternative.
-
Automate SQL Logins to DR Site
Here is how to automate copying your SQL logins to your DR server.