go to site As a DBA sometimes we came across the situation when we have to choose a best High Availability and Disaster recovery solutions.

go to site

http://wilsonrelocation.com/?q=what-is-forex what is forex Each has its own advantages and limitations.


To provide an accurate choice which technology to use, DBAs must have through understanding of business needs for high availability, How fast  should fail-over happen,how many replicas  required and if reads can happen on the secondary. Each SQL Server High availability technology has  short comings on a different dimensions.

اسعار اسهم مصفاة البترول الاردنية

here Here is a quick table for reference.

click here
http://theiu.org/?alisa=%D8%AE%D9%8A%D8%A7%D8%B1-%D8%AB%D9%86%D8%A7%D8%A6%D9%8A-%D9%81%D9%8A-%D8%A7%D9%84%D9%85%D9%85%D9%84%D9%83%D8%A9-%D8%A7%D9%84%D9%85%D8%AA%D8%AD%D8%AF%D8%A9&d0b=4b Feature  http://theshopsonelpaseo.com/?syzen=%D8%A7%D9%83%D8%AA%D8%AA%D8%A7%D8%A8%D8%A7%D8%AA-%D8%A7%D9%84%D8%A7%D8%B3%D9%87%D9%85-%D8%A7%D9%84%D8%B3%D8%B9%D9%88%D8%AF%D9%8A%D8%A9&08f=b2 Fail over clustering http://parts.powercut.co.uk/?risep=%D8%A7%D9%84%D8%AE%D9%8A%D8%A7%D8%B1%D8%A7%D8%AA-%D8%A7%D9%84%D8%AB%D9%86%D8%A7%D8%A6%D9%8A%D8%A9-%D8%A7%D9%84%D8%AA%D8%AF%D8%A7%D9%88%D9%84-%D8%A7%D9%84%D9%81%D9%8A%D8%B3%D8%A8%D9%88%D9%83&1eb=88 Database Mirroring  http://asect.org.uk/?ilyminaciya=%D8%AA%D8%AF%D8%A7%D9%88%D9%84-%D8%A7%D9%84%D8%A3%D8%B3%D9%87%D9%85-%D9%85%D8%A8%D8%A7%D8%B4%D8%B1&d2e=33 Log Shipping source url Transactional Replication
Storage redundancy ?  No Yes Yes Yes
 No need for special hardware? No Yes Yes Yes
Role change automatically Yes Yes No No
No need for additional server ? None Witness Monitor* Distributor*
Reports read from secondary ? NA No Read only Yes
Scope of availability Instance level Complete Database Complete Database Database Objects
 Multiple secondary client NA No Yes Yes
Auto redirection after failover Yes No: Need custom solution No: Need custom solution No: Need custom solution
Recovery Model Any Full Full Any