Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts tagged Mirroring

I’ll be doing a precon for SQLSaturday #422 in Oklahoma City on August 28th, 2015 titled “Creating a High Availability and Disaster Recovery Plan” .  If you are in the area or thinking of attending this event, I would love to have you in the class.  We are going to cover backups, windows clustering, AlwaysOn Failover Cluster […]

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 […]

I will be presenting two sessions at Dallas TechFest!  I am honored and excited to be speaking.  Dallas TechFest is a premiere technology conference that includes many technology areas like .Net, Java, Windows Phone, and of course SQL Server.  This year the conference has grown and expanded from one day to two days, and is […]

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: The Bear Necessities slide deck and sample code

Ryan Adams will be doing two presentations on SQL Mirroring this week.

If you have more than 4gig of RAM, consider enabling PAE and AWE.

You cannot mirror a database to two seperate servers, but there is an alternative.

Here is how to automate copying your SQL logins to your DR server.