<div>
It is quite a bit of data and the connection between the sites is only a T1 so I was looking for something that could do a bit level or differential type update to the DB. The DB is large but the changes from day to day are not that big.
</div>


It is quite a bit of data and the connection between the sites is only a T1 so I was looking for something that could do a bit level or differential type update to the DB. The DB is large but the changes from day to day are not that big.

<div>
Anyone else have some input on this? Not afraid to go with a 3rd party software package..
</div>


Anyone else have some input on this? Not afraid to go with a 3rd party software package..

<div>
ScottPletcher, any links to tutorials you think would be helpful?
</div>


ScottPletcher, any links to tutorials you think would be helpful?

<div>
<div class="content wysiwyg-content">
What is the best method to keep 2 SQL 2005 standard servers in sync with each other, with or without third party software? My intention is to keep a &quot;warm&quot; site as a disaster recovery option. Acceptable loss would be less than 24hrs of data but no more.
</div>
</div>


What is the best method to keep 2 SQL 2005 standard servers in sync with each other, with or without third party software? My intention is to keep a "warm" site as a disaster recovery option. Acceptable loss would be less than 24hrs of data but no more.

Keeping 2 SQL 2005 STD servers in sync

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Disaster Recovery is the planning for and creation of policies and procedures related to the resumption or continuation of an organization's functions following a catastrophic event. The term is most frequently used in relation to failure of networks, but DR preparations also include other business systems and personnel considerations.