MSSQL Server 2008 Redundancy/Mirror'ing, etc
Posted on 2010-08-18
I have an install of SQL 2008 Server running in Windows 2008 Server.
I need to setup of for redundancy or mirroring, pick the term that best fits, after reading more below.
So I want to have near real-time replication of data on a 2nd system. Near Real-Time, can mean within 5 or 10 minute of updates..
I am looking for guidance on how to approach this setup, and prerequisites, setup info, and gotcha's will be appreciated. I understand there may be more than one approach that can be used.
Initially, I am not expecting any load to be shared between these two MS SQL 2008 Servers. Just a One-Way Publish/Update.