<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I have an install of SQL 2008 Server running in Windows 2008 Server.<br />
<br />
I need to setup of for redundancy or mirroring, pick the term that best fits, after reading more below.<br />
<br />
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..<br />
<br />
I am looking for guidance on how to approach this setup, and prerequisites, setup info, and gotcha's will be appreciated. &nbsp;I understand there may be more than one approach that can be used. <br />
<br />
Initially, I am not expecting any load to be shared between these two MS SQL 2008 Servers. Just a One-Way Publish/Update.<br />
<br />
Thanks !<br />
<br />
Martin
</div>
</div>


Hi, 

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.

Thanks !

Martin

MSSQL Server 2008 Redundancy/Mirror'ing, etc

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.