分享我的知識 : SQL Server 2005 -Database mirroring

[watermelonyu]

SQL Server 2005 已經有類似 Oracle Data Guard 的功能了.

----

Database mirroring is a new SQL Server 2005 technology for increasing database availability. Database mirroring transfers transaction log records directly from one server to another and can quickly fail over to the standby server. You can code client applications to automatically redirect their connection information, and in the event of a failover, automatically connect to the standby server and database. Fast failover with minimal data loss has traditionally involved higher hardware cost and greater software complexity. Database mirroring, however, can fail over quickly with no loss of committed data, does not require proprietary hardware, and is easy to set up and manage.

[watermelonyu · Accepted solution]

It is good for me.