Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-12 : 07:17:11
|
| SP writes "Database mirroring was present in SQL server 6.5. How different is it in SQL Server 2005 apart from the automatic fail-over using witness. What is the reason for it being re-introduced in SQL Server 2005, after removing it in versions 7 & 2000?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-12 : 07:23:43
|
| The type of mirroring used in SQL 6.5 was a poor-man's version of RAID 1 that was controlled by SQL Server. It was removed in favor of using new hardware improvements and/or the Windows OS's built-in disk mirroring to achieve the same result. This improved performance by relieving SQL Server of these tasks and made it work with standard I/O operations more efficiently. It was not meant to provide failover capabilities, high availability, or data replication, which are the keys points that the SQL Server 2005 mirroring are meant to address. |
 |
|
|
bakerjon
Posting Yak Master
145 Posts |
|
|
|
|
|
Database Mirroring in SQL Server 2005 - How different is it?