Friday, June 10, 2011

Recovering Transactional Consistency Across SQL Servers

In order to maintain transactional consistency across separate SQL Servers (or across databases on the same server), SQL Server uses distributed transactions coordinator. 
 
In order to have a backup/recovery strategy that ensures transactional consistency in the event of database/system issues, transactions need to use marks.  When recovering transaction logs, use the WITH STOPATMARK option.

This strategy is required since SQL Server cannot restore transactional consistency across related database with point-in-time recovery.

No comments:

Post a Comment