SQL Server A to Z – Mirroring

While I’m working on my other little problem, let’s talk about database mirroring in SQL Server.В  Mirroring was first introduced in SQL 2005 as a high availability solution, and the technology remains mostly the same in SQL 2008, with a couple enhancements.В  With database mirroring, you can have a transactionally consistent hot-spare of your database, [...]

September 6, 2011  Tags: , ,   Posted in: Features  No Comments

Mirror, Mirror…

So, while I was discussing database snapshots in SQL Server, I kind of glossed over the subject of database mirroring, assuming you already had it set up in your environment.В  But maybe you don’t.В  So today I’m going to go through the steps involved in setting up database mirroring in SQL Server 2008.В  To keep [...]

March 21, 2011  Tags: , ,   Posted in: Features, General  No Comments