Собственно смущает метода которая используется SQLем.
Не будет ли возникать ошибок в момент частичной передачи данных, и будут ли они критическими для базы.

Пробовал ли кто-то подобное организовывать. Уж очень надоела УРБД....

если руки на месте - то осилите

вот осилившие
http://www.softpoint.ru/products_id4.htm

http://dbasurvivor.com/
Репликация ббывает трех типов:

http://screencast.com/t/KMmFXoeFKFE



А вот в частности про зеркалирование:

Soon a great battle took place between two giant beasts named Cluster and Log
Shipping, who had easily beaten down the inferior SQL Replication in a pay-per-view
event two months prior. Cluster and Log Shipping battled for years, neither giving an
inch to the other, until such time that they were both badly beaten, weakened, and
barely able to stand.
At the time of SQL Server 2005’s release, a great hero rose from the ashes of Cluster
and the ruins of Log Shipping. The hero’s name was Database Mirroring, and promised
that everything was going to be different. Database Mirroring promised real-time
synchronization of your data without the hassle of log shipping. Database Mirroring
promised faster failover without the need for a cluster. In short, Database Mirroring
promised the best of all other technologies, with none of the shortcomings, and even
brought along a witness to attest to its abilities.


Короче, очень рекомендую - бомбовская книга.